PREVIEW / stock_1hour / 2009-11-30

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-11-30.parquet
  size:    956 KB
  rows:    45,332
  symbols: 3,436

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
2009-11-30 05:00:00	AAPL	Stock	7.1786	7.1786	7.1786	7.1786	27020.0
2009-11-30 06:00:00	AAPL	Stock	7.1786	7.1786	7.1782	7.1782	33600.0
2009-11-30 07:00:00	AAPL	Stock	7.1643	7.2054	7.1639	7.2054	311080.0
2009-11-30 08:00:00	AAPL	Stock	7.2039	7.2393	7.1839	7.2143	2383248.0
2009-11-30 09:00:00	AAPL	Stock	7.2207	7.2211	7.1489	7.1771	68411280.0
2009-11-30 10:00:00	AAPL	Stock	7.1782	7.2	7.1518	7.1536	64642844.0
2009-11-30 11:00:00	AAPL	Stock	7.1539	7.1543	7.0989	7.1054	77339584.0
2009-11-30 12:00:00	AAPL	Stock	7.1054	7.125	7.1036	7.1161	33905508.0
2009-11-30 13:00:00	AAPL	Stock	7.1145	7.1557	7.1125	7.1479	43362284.0
2009-11-30 14:00:00	AAPL	Stock	7.1471	7.1479	7.1143	7.1239	26194980.0
2009-11-30 15:00:00	AAPL	Stock	7.1239	7.1679	7.1229	7.1411	81645004.0
2009-11-30 16:00:00	AAPL	Stock	7.1407	7.1834	7.1286	7.1396	18025084.0
2009-11-30 17:00:00	AAPL	Stock	7.1429	7.15	7.1381	7.1446	836976.0
2009-11-30 18:00:00	AAPL	Stock	7.1639	7.1639	7.1396	7.1396	336532.0
2009-11-30 19:00:00	AAPL	Stock	7.1411	7.1421	7.1179	7.1421	526820.0
2009-11-30 20:00:00	AAPL	Stock	7.1236	7.1236	7.1236	7.1236	6104.0
2009-11-30 04:00:00	MSFT	Stock	29.15	29.15	29.15	29.15	100.0
2009-11-30 08:00:00	MSFT	Stock	29.28	29.28	29.25	29.27	12440.0
2009-11-30 09:00:00	MSFT	Stock	29.27	29.27	29.0	29.14	5245105.0
2009-11-30 10:00:00	MSFT	Stock	29.15	29.39	29.142	29.19	6371505.0
2009-11-30 11:00:00	MSFT	Stock	29.19	29.2	29.012	29.11	4743139.0
2009-11-30 12:00:00	MSFT	Stock	29.1	29.18	29.1	29.13	3215899.0
2009-11-30 13:00:00	MSFT	Stock	29.135	29.34	29.13	29.31	4224532.0
2009-11-30 14:00:00	MSFT	Stock	29.32	29.378	29.26	29.29	4449624.0
2009-11-30 15:00:00	MSFT	Stock	29.28	29.45	29.28	29.41	9795718.0
2009-11-30 16:00:00	MSFT	Stock	29.41	29.45	29.203	29.41	4582534.0
2009-11-30 17:00:00	MSFT	Stock	29.41	29.44	29.404	29.44	422037.0
2009-11-30 18:00:00	MSFT	Stock	29.425	29.425	29.38	29.38	2327.0
2009-11-30 19:00:00	MSFT	Stock	29.39	29.39	29.39	29.39	100.0
2009-11-30 20:00:00	MSFT	Stock	29.14	29.14	29.14	29.14	1262.0
2009-11-30 08:00:00	NVDA	Stock	0.3228	0.3235	0.3228	0.3235	47840.0
2009-11-30 09:00:00	NVDA	Stock	0.321	0.3217	0.3179	0.32	50172360.0
2009-11-30 10:00:00	NVDA	Stock	0.32	0.324	0.3198	0.3223	47180800.0
2009-11-30 11:00:00	NVDA	Stock	0.3223	0.3223	0.3175	0.3193	55956640.0
2009-11-30 12:00:00	NVDA	Stock	0.3194	0.3213	0.3188	0.3198	38791040.0
2009-11-30 13:00:00	NVDA	Stock	0.3198	0.3235	0.319	0.3234	58201640.0
2009-11-30 14:00:00	NVDA	Stock	0.3233	0.3245	0.3225	0.3228	65595840.0
2009-11-30 15:00:00	NVDA	Stock	0.3228	0.3268	0.3228	0.3265	112261440.0
2009-11-30 16:00:00	NVDA	Stock	0.3265	0.3298	0.322	0.3285	35772080.0
2009-11-30 17:00:00	NVDA	Stock	0.3264	0.3278	0.3264	0.3275	11776760.0
2009-11-30 19:00:00	NVDA	Stock	0.328	0.328	0.328	0.328	8000.0
2009-11-30 07:00:00	AMZN	Stock	6.5975	6.5975	6.5975	6.5975	2000.0
2009-11-30 08:00:00	AMZN	Stock	6.6225	6.66	6.6225	6.6495	647920.0
2009-11-30 09:00:00	AMZN	Stock	6.6495	6.729	6.608	6.723	31206380.0
2009-11-30 10:00:00	AMZN	Stock	6.7235	6.7625	6.678	6.691	42324720.0
2009-11-30 11:00:00	AMZN	Stock	6.69	6.691	6.627	6.6765	27741940.0
2009-11-30 12:00:00	AMZN	Stock	6.6775	6.713	6.6745	6.703	18232100.0
2009-11-30 13:00:00	AMZN	Stock	6.7035	6.7325	6.688	6.727	14822040.0
2009-11-30 14:00:00	AMZN	Stock	6.7265	6.7385	6.713	6.7332	13800320.0
2009-11-30 15:00:00	AMZN	Stock	6.734	6.804	6.7335	6.795	46367320.0

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

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