PREVIEW / stock_1hour / 2009-06-30

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-06-30.parquet
  size:    866 KB
  rows:    42,576
  symbols: 3,335

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-06-30 08:00:00	AAPL	Stock	5.0893	5.0893	5.0679	5.0771	879116.0
2009-06-30 09:00:00	AAPL	Stock	5.075	5.1357	5.0743	5.1118	76655768.0
2009-06-30 10:00:00	AAPL	Stock	5.1118	5.1121	5.0643	5.0836	90088320.0
2009-06-30 11:00:00	AAPL	Stock	5.0832	5.0957	5.0671	5.0768	42842072.0
2009-06-30 12:00:00	AAPL	Stock	5.0768	5.0846	5.0646	5.0757	25681684.0
2009-06-30 13:00:00	AAPL	Stock	5.0754	5.0957	5.0711	5.0836	31913560.0
2009-06-30 14:00:00	AAPL	Stock	5.0832	5.0886	5.0729	5.0764	35703248.0
2009-06-30 15:00:00	AAPL	Stock	5.0763	5.1032	5.0711	5.09	83816040.0
2009-06-30 16:00:00	AAPL	Stock	5.0714	5.1032	5.0642	5.0868	39204312.0
2009-06-30 17:00:00	AAPL	Stock	5.0868	5.095	5.0821	5.0875	1232504.0
2009-06-30 18:00:00	AAPL	Stock	5.0936	5.0936	5.0821	5.0821	229348.0
2009-06-30 19:00:00	AAPL	Stock	5.0886	5.0893	5.0857	5.0857	22400.0
2009-06-30 05:00:00	MSFT	Stock	23.85	23.85	23.8	23.8	1476.0
2009-06-30 06:00:00	MSFT	Stock	23.84	23.84	23.84	23.84	1700.0
2009-06-30 08:00:00	MSFT	Stock	23.91	23.98	23.85	23.9	17708.0
2009-06-30 09:00:00	MSFT	Stock	23.93	24.24	23.93	24.22	6834505.0
2009-06-30 10:00:00	MSFT	Stock	24.22	24.24	23.77	23.919	14018924.0
2009-06-30 11:00:00	MSFT	Stock	23.92	23.92	23.75	23.76	5974674.0
2009-06-30 12:00:00	MSFT	Stock	23.76	23.85	23.73	23.81	3307564.0
2009-06-30 13:00:00	MSFT	Stock	23.81	23.83	23.63	23.67	3728448.0
2009-06-30 14:00:00	MSFT	Stock	23.68	23.78	23.66	23.715	5753782.0
2009-06-30 15:00:00	MSFT	Stock	23.71	23.88	23.65	23.77	16075956.0
2009-06-30 16:00:00	MSFT	Stock	23.78	24.032	23.72	23.77	9402751.0
2009-06-30 17:00:00	MSFT	Stock	23.77	23.89	23.77	23.89	282810.0
2009-06-30 18:00:00	MSFT	Stock	23.88	23.88	23.77	23.77	7530.0
2009-06-30 19:00:00	MSFT	Stock	23.85	23.85	23.81	23.85	8220.0
2009-06-30 08:00:00	NVDA	Stock	0.2882	0.292	0.2852	0.289	164000.0
2009-06-30 09:00:00	NVDA	Stock	0.2875	0.2922	0.283	0.286	131540440.0
2009-06-30 10:00:00	NVDA	Stock	0.286	0.286	0.2778	0.2835	136033080.0
2009-06-30 11:00:00	NVDA	Stock	0.2835	0.2835	0.28	0.2808	37781560.0
2009-06-30 12:00:00	NVDA	Stock	0.2809	0.2818	0.2792	0.2792	47785920.0
2009-06-30 13:00:00	NVDA	Stock	0.2792	0.2794	0.2778	0.2778	25793080.0
2009-06-30 14:00:00	NVDA	Stock	0.2778	0.2818	0.277	0.281	55454600.0
2009-06-30 15:00:00	NVDA	Stock	0.281	0.284	0.2798	0.2822	115673320.0
2009-06-30 16:00:00	NVDA	Stock	0.2822	0.283	0.2818	0.2822	29509760.0
2009-06-30 17:00:00	NVDA	Stock	0.2822	0.2828	0.2822	0.2825	896560.0
2009-06-30 18:00:00	NVDA	Stock	0.2825	0.283	0.2825	0.2825	157360.0
2009-06-30 06:00:00	AMZN	Stock	4.19	4.2175	4.19	4.2175	8000.0
2009-06-30 07:00:00	AMZN	Stock	4.2045	4.205	4.1995	4.205	108020.0
2009-06-30 08:00:00	AMZN	Stock	4.201	4.201	4.18	4.183	346460.0
2009-06-30 09:00:00	AMZN	Stock	4.183	4.246	4.1765	4.211	23235700.0
2009-06-30 10:00:00	AMZN	Stock	4.211	4.2119	4.1555	4.203	29022400.0
2009-06-30 11:00:00	AMZN	Stock	4.2015	4.208	4.164	4.178	19039340.0
2009-06-30 12:00:00	AMZN	Stock	4.179	4.1865	4.164	4.165	11965260.0
2009-06-30 13:00:00	AMZN	Stock	4.165	4.165	4.1265	4.137	16314200.0
2009-06-30 14:00:00	AMZN	Stock	4.1364	4.1695	4.1235	4.161	12602580.0
2009-06-30 15:00:00	AMZN	Stock	4.162	4.2	4.157	4.192	27989600.0
2009-06-30 16:00:00	AMZN	Stock	4.1755	4.1935	4.1755	4.18	12611760.0
2009-06-30 19:00:00	AMZN	Stock	4.189	4.189	4.189	4.189	6000.0
2009-06-30 07:00:00	TLT	Stock	94.25	94.92	94.25	94.8	3000.0

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

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