PREVIEW / stock_1hour / 2012-10-04

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-10-04.parquet
  size:    948 KB
  rows:    45,210
  symbols: 3,480

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
2012-10-04 04:00:00	AAPL	Stock	24.075	24.0857	24.0357	24.0357	25200.0
2012-10-04 05:00:00	AAPL	Stock	23.9329	24.0268	23.9329	24.0268	8400.0
2012-10-04 06:00:00	AAPL	Stock	24.0357	24.0493	24.0357	24.0429	42000.0
2012-10-04 07:00:00	AAPL	Stock	24.0321	24.0429	23.9604	23.9893	989296.0
2012-10-04 08:00:00	AAPL	Stock	23.9821	24.0304	23.9571	23.9821	2426928.0
2012-10-04 09:00:00	AAPL	Stock	23.9804	24.0389	23.8968	23.9732	58201612.0
2012-10-04 10:00:00	AAPL	Stock	23.9843	24.0804	23.9564	24.0171	57068200.0
2012-10-04 11:00:00	AAPL	Stock	24.0099	24.0179	23.8671	23.9586	38850784.0
2012-10-04 12:00:00	AAPL	Stock	23.9584	24.0	23.8132	23.8525	39353888.0
2012-10-04 13:00:00	AAPL	Stock	23.8521	23.875	23.7786	23.8411	38756564.0
2012-10-04 14:00:00	AAPL	Stock	23.8414	23.9268	23.7696	23.8954	43878100.0
2012-10-04 15:00:00	AAPL	Stock	23.8936	23.9707	23.8089	23.8175	59225432.0
2012-10-04 16:00:00	AAPL	Stock	23.8146	23.9831	23.775	23.7857	20752844.0
2012-10-04 17:00:00	AAPL	Stock	23.7861	23.8143	23.7779	23.7779	351960.0
2012-10-04 18:00:00	AAPL	Stock	23.7779	23.7821	23.7543	23.7543	322224.0
2012-10-04 19:00:00	AAPL	Stock	23.7611	23.7625	23.7543	23.7607	229684.0
2012-10-04 07:00:00	MSFT	Stock	30.06	30.07	29.84	29.99	7400.0
2012-10-04 08:00:00	MSFT	Stock	29.9	29.98	29.8	29.91	63258.0
2012-10-04 09:00:00	MSFT	Stock	29.92	30.0	29.581	29.63	5168105.0
2012-10-04 10:00:00	MSFT	Stock	29.63	29.8	29.57	29.749	7137012.0
2012-10-04 11:00:00	MSFT	Stock	29.745	29.755	29.64	29.73	4834402.0
2012-10-04 12:00:00	MSFT	Stock	29.735	29.83	29.7	29.79	3479766.0
2012-10-04 13:00:00	MSFT	Stock	29.79	29.9	29.78	29.89	2927132.0
2012-10-04 14:00:00	MSFT	Stock	29.88	29.95	29.8	29.94	4085713.0
2012-10-04 15:00:00	MSFT	Stock	29.93	30.03	29.89	30.015	12303831.0
2012-10-04 16:00:00	MSFT	Stock	30.025	30.03	29.817	30.0	1536056.0
2012-10-04 17:00:00	MSFT	Stock	29.96	30.03	29.96	30.01	14696.0
2012-10-04 18:00:00	MSFT	Stock	30.0	30.0	29.98	30.0	2460.0
2012-10-04 19:00:00	MSFT	Stock	29.99	30.0	29.95	30.0	5990.0
2012-10-04 08:00:00	NVDA	Stock	0.3263	0.3263	0.3263	0.3263	12000.0
2012-10-04 09:00:00	NVDA	Stock	0.3268	0.3298	0.325	0.329	45910320.0
2012-10-04 10:00:00	NVDA	Stock	0.329	0.3322	0.3285	0.3318	45308080.0
2012-10-04 11:00:00	NVDA	Stock	0.3319	0.3322	0.3308	0.3318	33635720.0
2012-10-04 12:00:00	NVDA	Stock	0.3318	0.3378	0.3315	0.3362	68678840.0
2012-10-04 13:00:00	NVDA	Stock	0.3361	0.3382	0.336	0.3382	57392400.0
2012-10-04 14:00:00	NVDA	Stock	0.3382	0.341	0.3375	0.34	63457240.0
2012-10-04 15:00:00	NVDA	Stock	0.3401	0.3425	0.3393	0.3405	122306040.0
2012-10-04 16:00:00	NVDA	Stock	0.3405	0.3406	0.3257	0.3257	52262520.0
2012-10-04 17:00:00	NVDA	Stock	0.3405	0.3405	0.34	0.3405	613520.0
2012-10-04 19:00:00	NVDA	Stock	0.34	0.34	0.34	0.34	8000.0
2012-10-04 08:00:00	AMZN	Stock	12.807	12.8345	12.807	12.825	138460.0
2012-10-04 09:00:00	AMZN	Stock	12.8105	12.935	12.765	12.9055	10099400.0
2012-10-04 10:00:00	AMZN	Stock	12.912	13.02	12.894	12.9425	11267060.0
2012-10-04 11:00:00	AMZN	Stock	12.9455	12.9619	12.891	12.9195	5568280.0
2012-10-04 12:00:00	AMZN	Stock	12.916	12.9605	12.913	12.952	3537860.0
2012-10-04 13:00:00	AMZN	Stock	12.9505	12.9925	12.9375	12.97	3266700.0
2012-10-04 14:00:00	AMZN	Stock	12.9715	13.0095	12.9449	13.0017	5188960.0
2012-10-04 15:00:00	AMZN	Stock	12.9965	13.076	12.9951	13.027	12737220.0
2012-10-04 16:00:00	AMZN	Stock	13.0235	13.03	12.8125	12.8125	1800680.0
2012-10-04 17:00:00	AMZN	Stock	13.0235	13.0235	13.0235	13.0235	195680.0

> showing 50 of 45,210 rows — these rows as CSV

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