PREVIEW / stock_1hour / 2009-10-12

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-10-12.parquet
  size:    860 KB
  rows:    41,801
  symbols: 3,357

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-12 06:00:00	AAPL	Stock	6.8529	6.8529	6.8214	6.8214	29456.0
2009-10-12 07:00:00	AAPL	Stock	6.8571	6.8579	6.8393	6.8393	93352.0
2009-10-12 08:00:00	AAPL	Stock	6.8393	6.8482	6.8054	6.8386	1136744.0
2009-10-12 09:00:00	AAPL	Stock	6.8407	6.8464	6.7982	6.8239	53448220.0
2009-10-12 10:00:00	AAPL	Stock	6.8246	6.8282	6.8036	6.8186	40554052.0
2009-10-12 11:00:00	AAPL	Stock	6.8186	6.8321	6.8054	6.8055	24539620.0
2009-10-12 12:00:00	AAPL	Stock	6.8054	6.8186	6.805	6.8164	22481172.0
2009-10-12 13:00:00	AAPL	Stock	6.8162	6.8192	6.8082	6.8143	15154944.0
2009-10-12 14:00:00	AAPL	Stock	6.8146	6.8154	6.7729	6.776	61287940.0
2009-10-12 15:00:00	AAPL	Stock	6.7761	6.8161	6.7757	6.8146	48500844.0
2009-10-12 16:00:00	AAPL	Stock	6.8146	6.8255	6.8068	6.8146	5271728.0
2009-10-12 17:00:00	AAPL	Stock	6.8179	6.8179	6.8118	6.8154	131124.0
2009-10-12 18:00:00	AAPL	Stock	6.8143	6.8175	6.81	6.81	71624.0
2009-10-12 19:00:00	AAPL	Stock	6.8125	6.8179	6.8036	6.8179	82684.0
2009-10-12 04:00:00	MSFT	Stock	25.83	25.83	25.83	25.83	174.0
2009-10-12 05:00:00	MSFT	Stock	25.83	25.87	25.83	25.87	326.0
2009-10-12 07:00:00	MSFT	Stock	25.78	25.78	25.75	25.75	3600.0
2009-10-12 08:00:00	MSFT	Stock	25.71	25.71	25.55	25.6	17239.0
2009-10-12 09:00:00	MSFT	Stock	25.6	25.76	25.6	25.75	2186248.0
2009-10-12 10:00:00	MSFT	Stock	25.75	25.89	25.75	25.85	3550884.0
2009-10-12 11:00:00	MSFT	Stock	25.86	25.87	25.74	25.76	3748714.0
2009-10-12 12:00:00	MSFT	Stock	25.76	25.78	25.72	25.75	2389662.0
2009-10-12 13:00:00	MSFT	Stock	25.755	25.8	25.7	25.725	3249720.0
2009-10-12 14:00:00	MSFT	Stock	25.72	25.74	25.55	25.642	5663231.0
2009-10-12 15:00:00	MSFT	Stock	25.65	25.72	25.63	25.71	5148959.0
2009-10-12 16:00:00	MSFT	Stock	25.72	25.803	25.66	25.67	2855350.0
2009-10-12 17:00:00	MSFT	Stock	25.67	25.68	25.67	25.68	2692.0
2009-10-12 18:00:00	MSFT	Stock	25.68	25.73	25.67	25.72	5651.0
2009-10-12 19:00:00	MSFT	Stock	25.7	25.73	25.65	25.73	3182.0
2009-10-12 05:00:00	NVDA	Stock	0.356	0.356	0.356	0.356	6000.0
2009-10-12 06:00:00	NVDA	Stock	0.3605	0.3625	0.3605	0.3625	54000.0
2009-10-12 07:00:00	NVDA	Stock	0.3625	0.3625	0.3475	0.3475	1434000.0
2009-10-12 08:00:00	NVDA	Stock	0.3495	0.3495	0.3475	0.3488	2412760.0
2009-10-12 09:00:00	NVDA	Stock	0.3488	0.3558	0.348	0.3502	92034520.0
2009-10-12 10:00:00	NVDA	Stock	0.3502	0.3548	0.35	0.354	84339520.0
2009-10-12 11:00:00	NVDA	Stock	0.3542	0.357	0.3538	0.3562	48003320.0
2009-10-12 12:00:00	NVDA	Stock	0.3562	0.3562	0.3542	0.355	26560760.0
2009-10-12 13:00:00	NVDA	Stock	0.3549	0.3555	0.3525	0.354	33603520.0
2009-10-12 14:00:00	NVDA	Stock	0.3538	0.354	0.3485	0.3508	70330960.0
2009-10-12 15:00:00	NVDA	Stock	0.3508	0.3513	0.3488	0.3502	127525960.0
2009-10-12 16:00:00	NVDA	Stock	0.3502	0.3518	0.3498	0.3502	6329360.0
2009-10-12 17:00:00	NVDA	Stock	0.3542	0.3542	0.3502	0.3502	84000.0
2009-10-12 18:00:00	NVDA	Stock	0.35	0.35	0.35	0.35	4000.0
2009-10-12 19:00:00	NVDA	Stock	0.3502	0.3505	0.3502	0.3505	128000.0
2009-10-12 07:00:00	AMZN	Stock	4.8	4.8	4.8	4.8	6000.0
2009-10-12 08:00:00	AMZN	Stock	4.804	4.8275	4.8035	4.8265	122560.0
2009-10-12 09:00:00	AMZN	Stock	4.829	4.829	4.7905	4.8035	8887120.0
2009-10-12 10:00:00	AMZN	Stock	4.8035	4.8035	4.7505	4.7585	14781800.0
2009-10-12 11:00:00	AMZN	Stock	4.7565	4.8042	4.74	4.7415	8864740.0
2009-10-12 12:00:00	AMZN	Stock	4.741	4.752	4.73	4.745	8390280.0

> showing 50 of 41,801 rows — these rows as CSV

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