PREVIEW / stock_1hour / 2010-11-16

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-11-16.parquet
  size:    960 KB
  rows:    46,342
  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
2010-11-16 05:00:00	AAPL	Stock	10.9775	10.9943	10.9775	10.9943	11200.0
2010-11-16 06:00:00	AAPL	Stock	10.9736	10.9746	10.9582	10.9632	35560.0
2010-11-16 07:00:00	AAPL	Stock	10.9607	10.9607	10.9036	10.9139	437416.0
2010-11-16 08:00:00	AAPL	Stock	10.9143	10.9693	10.8929	10.95	2769312.0
2010-11-16 09:00:00	AAPL	Stock	10.9507	10.9857	10.8875	10.9132	71101940.0
2010-11-16 10:00:00	AAPL	Stock	10.9114	10.9182	10.81	10.8306	115027836.0
2010-11-16 11:00:00	AAPL	Stock	10.8307	10.8311	10.7175	10.7643	137756192.0
2010-11-16 12:00:00	AAPL	Stock	10.7636	10.8086	10.7539	10.7953	66695020.0
2010-11-16 13:00:00	AAPL	Stock	10.7936	10.8375	10.7757	10.8279	48189176.0
2010-11-16 14:00:00	AAPL	Stock	10.8286	10.8393	10.7607	10.7768	53284532.0
2010-11-16 15:00:00	AAPL	Stock	10.7761	10.7839	10.69	10.7586	132721288.0
2010-11-16 16:00:00	AAPL	Stock	10.7643	10.9056	10.7482	10.7536	18494280.0
2010-11-16 17:00:00	AAPL	Stock	10.75	10.7668	10.75	10.7607	1229452.0
2010-11-16 18:00:00	AAPL	Stock	10.7646	10.7711	10.7579	10.7625	852320.0
2010-11-16 19:00:00	AAPL	Stock	10.7625	10.7782	10.7618	10.7782	314888.0
2010-11-16 04:00:00	MSFT	Stock	26.1	26.1	26.05	26.05	1050.0
2010-11-16 06:00:00	MSFT	Stock	26.05	26.05	26.05	26.05	100.0
2010-11-16 07:00:00	MSFT	Stock	26.01	26.05	25.97	26.03	14425.0
2010-11-16 08:00:00	MSFT	Stock	26.03	26.13	26.01	26.06	69166.0
2010-11-16 09:00:00	MSFT	Stock	26.05	26.07	25.69	25.79	9378777.0
2010-11-16 10:00:00	MSFT	Stock	25.79	25.93	25.745	25.81	10178941.0
2010-11-16 11:00:00	MSFT	Stock	25.805	25.84	25.65	25.81	8720570.0
2010-11-16 12:00:00	MSFT	Stock	25.81	25.85	25.73	25.825	5689916.0
2010-11-16 13:00:00	MSFT	Stock	25.82	25.9	25.78	25.88	5472802.0
2010-11-16 14:00:00	MSFT	Stock	25.88	25.92	25.79	25.9	6136376.0
2010-11-16 15:00:00	MSFT	Stock	25.892	25.9	25.66	25.79	12510832.0
2010-11-16 16:00:00	MSFT	Stock	25.805	25.84	25.72	25.81	3146304.0
2010-11-16 17:00:00	MSFT	Stock	25.799	25.81	25.79	25.79	55562.0
2010-11-16 18:00:00	MSFT	Stock	25.8	25.81	25.8	25.8	13115.0
2010-11-16 19:00:00	MSFT	Stock	25.84	25.9	25.84	25.85	3300.0
2010-11-16 08:00:00	NVDA	Stock	0.325	0.326	0.3225	0.3258	480160.0
2010-11-16 09:00:00	NVDA	Stock	0.3233	0.3265	0.3196	0.322	100782520.0
2010-11-16 10:00:00	NVDA	Stock	0.3219	0.3233	0.3204	0.321	134673120.0
2010-11-16 11:00:00	NVDA	Stock	0.3211	0.3215	0.3173	0.3188	113609000.0
2010-11-16 12:00:00	NVDA	Stock	0.3188	0.3205	0.3175	0.3188	79718320.0
2010-11-16 13:00:00	NVDA	Stock	0.3185	0.3223	0.3185	0.3218	51663560.0
2010-11-16 14:00:00	NVDA	Stock	0.3218	0.322	0.3193	0.32	38963520.0
2010-11-16 15:00:00	NVDA	Stock	0.3203	0.3208	0.3178	0.3178	169427480.0
2010-11-16 16:00:00	NVDA	Stock	0.319	0.3215	0.318	0.3195	31625680.0
2010-11-16 17:00:00	NVDA	Stock	0.318	0.3183	0.318	0.3183	504280.0
2010-11-16 18:00:00	NVDA	Stock	0.3185	0.3195	0.3185	0.3195	12000.0
2010-11-16 19:00:00	NVDA	Stock	0.3185	0.3185	0.3183	0.3183	92800.0
2010-11-16 04:00:00	AMZN	Stock	7.9515	7.9515	7.9515	7.9515	3500.0
2010-11-16 07:00:00	AMZN	Stock	7.9	7.9315	7.894	7.894	37800.0
2010-11-16 08:00:00	AMZN	Stock	7.894	7.935	7.89	7.9	142980.0
2010-11-16 09:00:00	AMZN	Stock	7.904	8.0455	7.9	8.021	21267760.0
2010-11-16 10:00:00	AMZN	Stock	8.02	8.0295	7.9375	7.969	24023960.0
2010-11-16 11:00:00	AMZN	Stock	7.969	7.97	7.8385	7.894	24523240.0
2010-11-16 12:00:00	AMZN	Stock	7.8951	7.9145	7.8645	7.9105	10661360.0
2010-11-16 13:00:00	AMZN	Stock	7.912	7.9485	7.8765	7.9445	11084800.0

> showing 50 of 46,342 rows — these rows as CSV

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