PREVIEW / stock_1hour / 2009-10-06

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-10-06.parquet
  size:    890 KB
  rows:    42,447
  symbols: 3,394

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-10-06 04:00:00	AAPL	Stock	6.6786	6.6786	6.6786	6.6786	11200.0
2009-10-06 05:00:00	AAPL	Stock	6.6786	6.6911	6.6786	6.6911	9800.0
2009-10-06 06:00:00	AAPL	Stock	6.6875	6.6875	6.6711	6.6786	44408.0
2009-10-06 07:00:00	AAPL	Stock	6.6904	6.6918	6.6643	6.6871	256844.0
2009-10-06 08:00:00	AAPL	Stock	6.6875	6.7111	6.6786	6.7107	3271772.0
2009-10-06 09:00:00	AAPL	Stock	6.7107	6.7375	6.6893	6.7211	77576996.0
2009-10-06 10:00:00	AAPL	Stock	6.7214	6.7668	6.7186	6.7521	100528736.0
2009-10-06 11:00:00	AAPL	Stock	6.7529	6.7782	6.7504	6.7575	64633716.0
2009-10-06 12:00:00	AAPL	Stock	6.7575	6.7768	6.7539	6.7611	46420052.0
2009-10-06 13:00:00	AAPL	Stock	6.7611	6.7743	6.7343	6.7407	61343352.0
2009-10-06 14:00:00	AAPL	Stock	6.7407	6.7436	6.7	6.7321	70395612.0
2009-10-06 15:00:00	AAPL	Stock	6.7318	6.7857	6.7279	6.7857	109369372.0
2009-10-06 16:00:00	AAPL	Stock	6.7857	6.7929	6.7536	6.7893	14797300.0
2009-10-06 17:00:00	AAPL	Stock	6.7871	6.7893	6.7825	6.7875	262808.0
2009-10-06 18:00:00	AAPL	Stock	6.7893	6.7921	6.785	6.7871	638036.0
2009-10-06 19:00:00	AAPL	Stock	6.7871	6.7882	6.7768	6.7821	541800.0
2009-10-06 07:00:00	MSFT	Stock	24.88	24.88	24.85	24.87	3701.0
2009-10-06 08:00:00	MSFT	Stock	24.87	24.87	24.74	24.75	23644.0
2009-10-06 09:00:00	MSFT	Stock	24.78	24.92	24.65	24.91	6471487.0
2009-10-06 10:00:00	MSFT	Stock	24.91	25.08	24.88	25.03	7905189.0
2009-10-06 11:00:00	MSFT	Stock	25.031	25.21	25.03	25.13	6369888.0
2009-10-06 12:00:00	MSFT	Stock	25.12	25.18	25.03	25.09	4313919.0
2009-10-06 13:00:00	MSFT	Stock	25.09	25.16	25.04	25.072	4525328.0
2009-10-06 14:00:00	MSFT	Stock	25.08	25.11	24.92	24.99	6347741.0
2009-10-06 15:00:00	MSFT	Stock	24.99	25.17	24.97	25.12	8584483.0
2009-10-06 16:00:00	MSFT	Stock	25.12	25.17	25.033	25.11	2386120.0
2009-10-06 17:00:00	MSFT	Stock	24.64	25.14	24.64	25.14	47250.0
2009-10-06 18:00:00	MSFT	Stock	25.11	25.16	25.11	25.15	23121.0
2009-10-06 19:00:00	MSFT	Stock	25.15	25.16	25.15	25.16	1232.0
2009-10-06 20:00:00	MSFT	Stock	24.64	24.64	24.64	24.64	93600.0
2009-10-06 07:00:00	NVDA	Stock	0.3538	0.3538	0.3513	0.3513	8000.0
2009-10-06 08:00:00	NVDA	Stock	0.3462	0.3553	0.3462	0.3478	237000.0
2009-10-06 09:00:00	NVDA	Stock	0.349	0.3538	0.347	0.3523	112682920.0
2009-10-06 10:00:00	NVDA	Stock	0.3525	0.3535	0.3493	0.3495	145748400.0
2009-10-06 11:00:00	NVDA	Stock	0.3493	0.3545	0.3493	0.354	97789400.0
2009-10-06 12:00:00	NVDA	Stock	0.3542	0.3562	0.3538	0.3538	66320760.0
2009-10-06 13:00:00	NVDA	Stock	0.354	0.354	0.3505	0.3505	78781640.0
2009-10-06 14:00:00	NVDA	Stock	0.3505	0.3508	0.3462	0.3485	119068320.0
2009-10-06 15:00:00	NVDA	Stock	0.3488	0.352	0.3482	0.3502	122947160.0
2009-10-06 16:00:00	NVDA	Stock	0.3498	0.3511	0.3495	0.3495	2672120.0
2009-10-06 17:00:00	NVDA	Stock	0.3495	0.3511	0.3495	0.3511	3252000.0
2009-10-06 19:00:00	NVDA	Stock	0.3495	0.3495	0.3495	0.3495	94480.0
2009-10-06 07:00:00	AMZN	Stock	4.517	4.517	4.475	4.5	16000.0
2009-10-06 08:00:00	AMZN	Stock	4.4875	4.4925	4.475	4.48	77100.0
2009-10-06 09:00:00	AMZN	Stock	4.492	4.503	4.42	4.486	26655180.0
2009-10-06 10:00:00	AMZN	Stock	4.4875	4.512	4.4775	4.497	15164120.0
2009-10-06 11:00:00	AMZN	Stock	4.497	4.5215	4.495	4.5005	15095200.0
2009-10-06 12:00:00	AMZN	Stock	4.5005	4.517	4.4955	4.512	10734440.0
2009-10-06 13:00:00	AMZN	Stock	4.511	4.519	4.4915	4.504	14632080.0
2009-10-06 14:00:00	AMZN	Stock	4.5045	4.5078	4.4705	4.502	13983980.0

> showing 50 of 42,447 rows — these rows as CSV

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