PREVIEW / stock_1hour / 2009-05-19

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-05-19.parquet
  size:    845 KB
  rows:    41,612
  symbols: 3,356

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-05-19 04:00:00	AAPL	Stock	4.5557	4.5768	4.5557	4.5618	25200.0
2009-05-19 05:00:00	AAPL	Stock	4.5786	4.5911	4.5786	4.5911	20916.0
2009-05-19 06:00:00	AAPL	Stock	4.5739	4.5871	4.5286	4.5871	102200.0
2009-05-19 07:00:00	AAPL	Stock	4.5646	4.5646	4.5571	4.5607	178836.0
2009-05-19 08:00:00	AAPL	Stock	4.5607	4.5639	4.5493	4.5518	1139180.0
2009-05-19 09:00:00	AAPL	Stock	4.5518	4.5518	4.4907	4.5307	71600368.0
2009-05-19 10:00:00	AAPL	Stock	4.53	4.5814	4.5275	4.5675	71908284.0
2009-05-19 11:00:00	AAPL	Stock	4.5679	4.5779	4.5479	4.5711	34652548.0
2009-05-19 12:00:00	AAPL	Stock	4.5708	4.5982	4.5675	4.5725	36151416.0
2009-05-19 13:00:00	AAPL	Stock	4.5718	4.6075	4.5661	4.5991	39847332.0
2009-05-19 14:00:00	AAPL	Stock	4.5989	4.6182	4.5879	4.6043	37434292.0
2009-05-19 15:00:00	AAPL	Stock	4.6036	4.6096	4.5475	4.5525	64091020.0
2009-05-19 16:00:00	AAPL	Stock	4.5525	4.5884	4.5429	4.545	9194500.0
2009-05-19 17:00:00	AAPL	Stock	4.5429	4.5514	4.5429	4.5514	197988.0
2009-05-19 18:00:00	AAPL	Stock	4.5529	4.5571	4.5518	4.5571	353444.0
2009-05-19 19:00:00	AAPL	Stock	4.5571	4.5571	4.5536	4.5571	290640.0
2009-05-19 20:00:00	AAPL	Stock	4.57	4.57	4.5239	4.5239	159600.0
2009-05-19 04:00:00	MSFT	Stock	19.94	20.61	19.94	20.61	2250.0
2009-05-19 07:00:00	MSFT	Stock	20.5	20.5	20.5	20.5	1695.0
2009-05-19 08:00:00	MSFT	Stock	20.56	20.6	20.46	20.47	8677.0
2009-05-19 09:00:00	MSFT	Stock	20.47	20.54	20.3	20.44	5953072.0
2009-05-19 10:00:00	MSFT	Stock	20.43	20.74	20.41	20.63	7743656.0
2009-05-19 11:00:00	MSFT	Stock	20.62	20.655	20.46	20.46	4465376.0
2009-05-19 12:00:00	MSFT	Stock	20.46	20.52	20.46	20.51	2367541.0
2009-05-19 13:00:00	MSFT	Stock	20.51	20.61	20.51	20.551	3456117.0
2009-05-19 14:00:00	MSFT	Stock	20.558	20.57	20.42	20.423	6610946.0
2009-05-19 15:00:00	MSFT	Stock	20.43	20.47	20.25	20.31	12528621.0
2009-05-19 16:00:00	MSFT	Stock	20.31	20.51	20.226	20.3	2424540.0
2009-05-19 17:00:00	MSFT	Stock	20.3	20.3	20.26	20.27	9447.0
2009-05-19 19:00:00	MSFT	Stock	20.31	20.4	20.28	20.4	14700.0
2009-05-19 20:00:00	MSFT	Stock	20.51	20.51	20.47	20.47	44400.0
2009-05-19 04:00:00	NVDA	Stock	0.2335	0.2335	0.2335	0.2335	10400.0
2009-05-19 05:00:00	NVDA	Stock	0.2335	0.2335	0.2335	0.2335	4000.0
2009-05-19 07:00:00	NVDA	Stock	0.236	0.2372	0.236	0.2372	74400.0
2009-05-19 08:00:00	NVDA	Stock	0.2345	0.2372	0.2325	0.234	488520.0
2009-05-19 09:00:00	NVDA	Stock	0.2342	0.2368	0.2295	0.231	124357920.0
2009-05-19 10:00:00	NVDA	Stock	0.231	0.239	0.23	0.2358	163599640.0
2009-05-19 11:00:00	NVDA	Stock	0.236	0.2372	0.2338	0.236	114663480.0
2009-05-19 12:00:00	NVDA	Stock	0.2362	0.2362	0.2335	0.234	70420480.0
2009-05-19 13:00:00	NVDA	Stock	0.234	0.237	0.234	0.2368	82400160.0
2009-05-19 14:00:00	NVDA	Stock	0.2368	0.239	0.2355	0.2378	76446280.0
2009-05-19 15:00:00	NVDA	Stock	0.2379	0.2385	0.2358	0.2365	204108160.0
2009-05-19 16:00:00	NVDA	Stock	0.2365	0.2372	0.233	0.233	18661440.0
2009-05-19 17:00:00	NVDA	Stock	0.2338	0.2338	0.2338	0.2338	40000.0
2009-05-19 18:00:00	NVDA	Stock	0.2338	0.2348	0.2338	0.2348	280000.0
2009-05-19 19:00:00	NVDA	Stock	0.2328	0.2328	0.2328	0.2328	11800.0
2009-05-19 08:00:00	AMZN	Stock	3.7925	3.8125	3.783	3.7875	122200.0
2009-05-19 09:00:00	AMZN	Stock	3.7875	3.845	3.756	3.801	23713200.0
2009-05-19 10:00:00	AMZN	Stock	3.8005	3.845	3.79	3.8305	22984420.0
2009-05-19 11:00:00	AMZN	Stock	3.8305	3.8475	3.805	3.837	18386500.0

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

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