PREVIEW / stock_1hour / 2011-03-04

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-03-04.parquet
  size:    927 KB
  rows:    43,857
  symbols: 3,531

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
2011-03-04 04:00:00	AAPL	Stock	12.8571	12.8571	12.8571	12.8571	2800.0
2011-03-04 05:00:00	AAPL	Stock	12.9	12.9082	12.9	12.9082	30100.0
2011-03-04 06:00:00	AAPL	Stock	12.9154	12.9154	12.9107	12.9107	28000.0
2011-03-04 07:00:00	AAPL	Stock	12.9018	12.9018	12.8682	12.895	806344.0
2011-03-04 08:00:00	AAPL	Stock	12.8929	12.9229	12.8668	12.8736	5761588.0
2011-03-04 09:00:00	AAPL	Stock	12.8729	12.8879	12.7989	12.827	86147432.0
2011-03-04 10:00:00	AAPL	Stock	12.8279	12.85	12.7796	12.8452	86140040.0
2011-03-04 11:00:00	AAPL	Stock	12.8446	12.8532	12.8218	12.8243	46689916.0
2011-03-04 12:00:00	AAPL	Stock	12.8236	12.8346	12.7768	12.7918	64169280.0
2011-03-04 13:00:00	AAPL	Stock	12.7923	12.8204	12.7843	12.8158	30329964.0
2011-03-04 14:00:00	AAPL	Stock	12.8193	12.8214	12.7914	12.8211	22632960.0
2011-03-04 15:00:00	AAPL	Stock	12.8218	12.8571	12.7896	12.8571	77967260.0
2011-03-04 16:00:00	AAPL	Stock	12.8571	12.8607	12.8177	12.8568	9051056.0
2011-03-04 17:00:00	AAPL	Stock	12.8568	12.8589	12.8518	12.8518	233324.0
2011-03-04 18:00:00	AAPL	Stock	12.8536	12.8625	12.8493	12.86	454384.0
2011-03-04 19:00:00	AAPL	Stock	12.8593	12.8607	12.8521	12.8575	181916.0
2011-03-04 06:00:00	MSFT	Stock	26.35	26.35	26.35	26.35	200.0
2011-03-04 07:00:00	MSFT	Stock	26.3	26.36	26.2	26.24	4400.0
2011-03-04 08:00:00	MSFT	Stock	26.23	26.3	26.15	26.18	47464.0
2011-03-04 09:00:00	MSFT	Stock	26.18	26.24	26.14	26.185	6944955.0
2011-03-04 10:00:00	MSFT	Stock	26.19	26.2	26.09	26.13	11210997.0
2011-03-04 11:00:00	MSFT	Stock	26.13	26.2	26.06	26.075	7286067.0
2011-03-04 12:00:00	MSFT	Stock	26.07	26.09	25.89	25.995	10727905.0
2011-03-04 13:00:00	MSFT	Stock	25.995	26.01	25.87	25.89	7166155.0
2011-03-04 14:00:00	MSFT	Stock	25.89	25.95	25.82	25.949	7750852.0
2011-03-04 15:00:00	MSFT	Stock	25.95	26.01	25.8	25.97	16659953.0
2011-03-04 16:00:00	MSFT	Stock	25.97	26.011	25.87	25.98	2101871.0
2011-03-04 17:00:00	MSFT	Stock	25.98	26.0	25.97	25.97	16200.0
2011-03-04 18:00:00	MSFT	Stock	25.95	26.0	25.95	25.99	32187.0
2011-03-04 19:00:00	MSFT	Stock	26.0	26.01	25.99	26.01	4250.0
2011-03-04 08:00:00	NVDA	Stock	0.525	0.5265	0.522	0.522	870920.0
2011-03-04 09:00:00	NVDA	Stock	0.522	0.5238	0.5133	0.5205	144680040.0
2011-03-04 10:00:00	NVDA	Stock	0.5205	0.5272	0.5178	0.526	225540240.0
2011-03-04 11:00:00	NVDA	Stock	0.526	0.5275	0.5188	0.5192	111912440.0
2011-03-04 12:00:00	NVDA	Stock	0.5192	0.5202	0.5168	0.5185	123594680.0
2011-03-04 13:00:00	NVDA	Stock	0.5185	0.5213	0.5168	0.519	84050200.0
2011-03-04 14:00:00	NVDA	Stock	0.5192	0.5195	0.5173	0.5183	77871480.0
2011-03-04 15:00:00	NVDA	Stock	0.5183	0.5213	0.5165	0.5192	155437480.0
2011-03-04 16:00:00	NVDA	Stock	0.52	0.5201	0.5178	0.5192	4671880.0
2011-03-04 17:00:00	NVDA	Stock	0.5192	0.5195	0.5192	0.5195	252920.0
2011-03-04 18:00:00	NVDA	Stock	0.52	0.52	0.519	0.519	36480.0
2011-03-04 19:00:00	NVDA	Stock	0.5195	0.5195	0.519	0.519	94000.0
2011-03-04 08:00:00	AMZN	Stock	8.663	8.663	8.615	8.615	36000.0
2011-03-04 09:00:00	AMZN	Stock	8.6175	8.6375	8.5415	8.569	11461720.0
2011-03-04 10:00:00	AMZN	Stock	8.5695	8.5895	8.5285	8.5825	17965960.0
2011-03-04 11:00:00	AMZN	Stock	8.584	8.5885	8.5415	8.5495	11817000.0
2011-03-04 12:00:00	AMZN	Stock	8.5475	8.5475	8.4755	8.5027	11624680.0
2011-03-04 13:00:00	AMZN	Stock	8.5035	8.5485	8.5025	8.5235	8734500.0
2011-03-04 14:00:00	AMZN	Stock	8.523	8.527	8.493	8.5125	10458980.0
2011-03-04 15:00:00	AMZN	Stock	8.5125	8.585	8.497	8.5805	21124660.0

> showing 50 of 43,857 rows — these rows as CSV

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