PREVIEW / stock_1hour / 2009-12-17

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-12-17.parquet
  size:    891 KB
  rows:    42,424
  symbols: 3,427

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-12-17 04:00:00	AAPL	Stock	6.9589	6.9589	6.9304	6.9304	11200.0
2009-12-17 07:00:00	AAPL	Stock	6.9286	6.9386	6.9196	6.9196	72800.0
2009-12-17 08:00:00	AAPL	Stock	6.9393	6.9429	6.9071	6.9268	1204784.0
2009-12-17 09:00:00	AAPL	Stock	6.9214	6.965	6.8879	6.8918	50054620.0
2009-12-17 10:00:00	AAPL	Stock	6.8907	6.9071	6.8536	6.8932	116866932.0
2009-12-17 11:00:00	AAPL	Stock	6.8936	6.9164	6.8815	6.8921	45890684.0
2009-12-17 12:00:00	AAPL	Stock	6.8921	6.8936	6.8539	6.8735	36838004.0
2009-12-17 13:00:00	AAPL	Stock	6.8736	6.8829	6.8657	6.8789	25673340.0
2009-12-17 14:00:00	AAPL	Stock	6.8789	6.8879	6.8679	6.8786	25332636.0
2009-12-17 15:00:00	AAPL	Stock	6.8791	6.8875	6.8489	6.8489	58594536.0
2009-12-17 16:00:00	AAPL	Stock	6.8489	6.9664	6.8214	6.8929	21408184.0
2009-12-17 17:00:00	AAPL	Stock	6.8946	6.9	6.8911	6.8929	1540196.0
2009-12-17 18:00:00	AAPL	Stock	6.8932	6.9036	6.8521	6.9025	1120840.0
2009-12-17 19:00:00	AAPL	Stock	6.9018	6.9025	6.8929	6.8946	205688.0
2009-12-17 05:00:00	MSFT	Stock	29.99	29.99	29.99	29.99	100.0
2009-12-17 07:00:00	MSFT	Stock	30.04	30.04	29.86	29.86	4730.0
2009-12-17 08:00:00	MSFT	Stock	29.98	29.98	29.95	29.95	6515.0
2009-12-17 09:00:00	MSFT	Stock	29.99	29.99	29.78	29.78	5674391.0
2009-12-17 10:00:00	MSFT	Stock	29.78	29.86	29.7	29.76	7977601.0
2009-12-17 11:00:00	MSFT	Stock	29.77	29.79	29.63	29.67	6116435.0
2009-12-17 12:00:00	MSFT	Stock	29.675	29.68	29.6	29.617	3516452.0
2009-12-17 13:00:00	MSFT	Stock	29.613	29.678	29.57	29.6	3028392.0
2009-12-17 14:00:00	MSFT	Stock	29.6	29.69	29.6	29.65	3340643.0
2009-12-17 15:00:00	MSFT	Stock	29.65	29.75	29.6	29.62	9481500.0
2009-12-17 16:00:00	MSFT	Stock	29.6	30.1	29.53	29.67	3445217.0
2009-12-17 17:00:00	MSFT	Stock	29.67	29.8	29.67	29.76	12260.0
2009-12-17 18:00:00	MSFT	Stock	29.76	29.79	29.6	29.75	29222.0
2009-12-17 19:00:00	MSFT	Stock	29.75	29.81	29.75	29.8	9428.0
2009-12-17 07:00:00	NVDA	Stock	0.4188	0.4188	0.4162	0.4162	144000.0
2009-12-17 08:00:00	NVDA	Stock	0.4162	0.425	0.4162	0.4245	3357440.0
2009-12-17 09:00:00	NVDA	Stock	0.425	0.437	0.4232	0.4282	289423200.0
2009-12-17 10:00:00	NVDA	Stock	0.4282	0.4308	0.4165	0.4195	240974040.0
2009-12-17 11:00:00	NVDA	Stock	0.4198	0.4213	0.4145	0.4152	100733640.0
2009-12-17 12:00:00	NVDA	Stock	0.4152	0.4185	0.415	0.4173	56435160.0
2009-12-17 13:00:00	NVDA	Stock	0.4173	0.421	0.4173	0.42	62523120.0
2009-12-17 14:00:00	NVDA	Stock	0.4201	0.4225	0.4182	0.421	80434840.0
2009-12-17 15:00:00	NVDA	Stock	0.421	0.4226	0.4198	0.4213	163377960.0
2009-12-17 16:00:00	NVDA	Stock	0.4213	0.4238	0.4165	0.4213	8545760.0
2009-12-17 17:00:00	NVDA	Stock	0.4208	0.425	0.4205	0.425	52000.0
2009-12-17 18:00:00	NVDA	Stock	0.4238	0.4238	0.4238	0.4238	8000.0
2009-12-17 19:00:00	NVDA	Stock	0.4245	0.4245	0.4238	0.4238	56000.0
2009-12-17 05:00:00	AMZN	Stock	6.3945	6.4225	6.3945	6.4225	10000.0
2009-12-17 06:00:00	AMZN	Stock	6.4	6.4	6.3945	6.4	8300.0
2009-12-17 07:00:00	AMZN	Stock	6.4	6.47	6.4	6.46	566480.0
2009-12-17 08:00:00	AMZN	Stock	6.4595	6.47	6.44	6.46	1352740.0
2009-12-17 09:00:00	AMZN	Stock	6.464	6.504	6.42	6.422	33544280.0
2009-12-17 10:00:00	AMZN	Stock	6.421	6.4475	6.402	6.4415	35137440.0
2009-12-17 11:00:00	AMZN	Stock	6.4425	6.4595	6.351	6.3775	29726180.0
2009-12-17 12:00:00	AMZN	Stock	6.378	6.387	6.353	6.3775	14530520.0
2009-12-17 13:00:00	AMZN	Stock	6.378	6.38	6.355	6.371	10009660.0

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

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