PREVIEW / stock_1hour / 2013-01-02

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-01-02.parquet
  size:    1005 KB
  rows:    47,298
  symbols: 3,517

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2013-01-02 04:00:00	AAPL	Stock	19.2854	19.375	19.2504	19.375	87360.0
2013-01-02 05:00:00	AAPL	Stock	19.3929	19.4929	19.3607	19.4554	220416.0
2013-01-02 06:00:00	AAPL	Stock	19.4443	19.5321	19.4443	19.4643	536704.0
2013-01-02 07:00:00	AAPL	Stock	19.4543	19.5939	19.4411	19.5439	3396848.0
2013-01-02 08:00:00	AAPL	Stock	19.5439	19.6339	19.4607	19.6243	8747900.0
2013-01-02 09:00:00	AAPL	Stock	19.6293	19.8214	19.5954	19.7143	138964280.0
2013-01-02 10:00:00	AAPL	Stock	19.7143	19.7168	19.5407	19.5768	98042392.0
2013-01-02 11:00:00	AAPL	Stock	19.5754	19.6041	19.3757	19.395	78751624.0
2013-01-02 12:00:00	AAPL	Stock	19.3939	19.4821	19.3439	19.4821	50666392.0
2013-01-02 13:00:00	AAPL	Stock	19.4821	19.5625	19.4321	19.4539	38693116.0
2013-01-02 14:00:00	AAPL	Stock	19.4539	19.5446	19.4443	19.5354	32095448.0
2013-01-02 15:00:00	AAPL	Stock	19.5357	19.7143	19.5193	19.5968	86595656.0
2013-01-02 16:00:00	AAPL	Stock	19.5968	19.6179	19.4047	19.605	15482292.0
2013-01-02 17:00:00	AAPL	Stock	19.6089	19.6143	19.6014	19.6054	455532.0
2013-01-02 18:00:00	AAPL	Stock	19.6036	19.6118	19.5964	19.6018	405216.0
2013-01-02 19:00:00	AAPL	Stock	19.5993	19.6018	19.5832	19.5836	298872.0
2013-01-02 04:00:00	MSFT	Stock	26.99	26.99	26.99	26.99	2000.0
2013-01-02 06:00:00	MSFT	Stock	27.23	27.26	27.23	27.26	899.0
2013-01-02 07:00:00	MSFT	Stock	27.16	27.16	27.05	27.15	8438.0
2013-01-02 08:00:00	MSFT	Stock	27.14	27.2	27.08	27.17	116079.0
2013-01-02 09:00:00	MSFT	Stock	27.17	27.4	26.73	27.324	9300567.0
2013-01-02 10:00:00	MSFT	Stock	27.325	27.335	27.21	27.215	8086581.0
2013-01-02 11:00:00	MSFT	Stock	27.215	27.27	27.15	27.205	5900479.0
2013-01-02 12:00:00	MSFT	Stock	27.21	27.24	27.16	27.182	3901097.0
2013-01-02 13:00:00	MSFT	Stock	27.185	27.25	27.17	27.24	3695538.0
2013-01-02 14:00:00	MSFT	Stock	27.235	27.35	27.22	27.305	5647785.0
2013-01-02 15:00:00	MSFT	Stock	27.3	27.73	27.29	27.65	12083050.0
2013-01-02 16:00:00	MSFT	Stock	27.64	27.67	27.212	27.56	3791477.0
2013-01-02 17:00:00	MSFT	Stock	27.57	27.57	27.218	27.55	46669.0
2013-01-02 18:00:00	MSFT	Stock	27.53	27.53	27.52	27.52	3793.0
2013-01-02 19:00:00	MSFT	Stock	27.54	27.54	27.52	27.52	3600.0
2013-01-02 06:00:00	NVDA	Stock	0.3203	0.3203	0.3203	0.3203	4000.0
2013-01-02 07:00:00	NVDA	Stock	0.315	0.315	0.315	0.315	12000.0
2013-01-02 08:00:00	NVDA	Stock	0.315	0.3185	0.3138	0.3138	723960.0
2013-01-02 09:00:00	NVDA	Stock	0.3125	0.3168	0.3125	0.3135	63644480.0
2013-01-02 10:00:00	NVDA	Stock	0.3138	0.3183	0.3133	0.3168	87718640.0
2013-01-02 11:00:00	NVDA	Stock	0.3168	0.3183	0.315	0.3153	54628240.0
2013-01-02 12:00:00	NVDA	Stock	0.3155	0.3163	0.3145	0.3155	50351200.0
2013-01-02 13:00:00	NVDA	Stock	0.3153	0.316	0.3145	0.315	43619040.0
2013-01-02 14:00:00	NVDA	Stock	0.3153	0.316	0.3145	0.3153	44851040.0
2013-01-02 15:00:00	NVDA	Stock	0.315	0.3183	0.315	0.318	109732360.0
2013-01-02 16:00:00	NVDA	Stock	0.3178	0.3185	0.3159	0.3169	3638560.0
2013-01-02 19:00:00	NVDA	Stock	0.318	0.318	0.318	0.318	8000.0
2013-01-02 06:00:00	AMZN	Stock	12.7	12.7	12.67	12.67	6000.0
2013-01-02 07:00:00	AMZN	Stock	12.725	12.8445	12.725	12.7525	87300.0
2013-01-02 08:00:00	AMZN	Stock	12.756	12.772	12.557	12.765	307000.0
2013-01-02 09:00:00	AMZN	Stock	12.7695	12.905	12.557	12.7922	14485380.0
2013-01-02 10:00:00	AMZN	Stock	12.802	12.823	12.6825	12.7242	11783400.0
2013-01-02 11:00:00	AMZN	Stock	12.724	12.742	12.663	12.6765	7537700.0
2013-01-02 12:00:00	AMZN	Stock	12.6712	12.775	12.665	12.7674	5453060.0

> showing 50 of 47,298 rows — these rows as CSV

> unlock the full archive -- $79 one-time