PREVIEW / stock_1hour / 2009-09-18

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-09-18.parquet
  size:    923 KB
  rows:    43,449
  symbols: 3,400

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-09-18 06:00:00	AAPL	Stock	6.5714	6.6214	6.5543	6.6143	372344.0
2009-09-18 07:00:00	AAPL	Stock	6.6054	6.625	6.5993	6.6125	578116.0
2009-09-18 08:00:00	AAPL	Stock	6.6082	6.6321	6.5936	6.6289	3215520.0
2009-09-18 09:00:00	AAPL	Stock	6.63	6.6625	6.6196	6.6557	177908276.0
2009-09-18 10:00:00	AAPL	Stock	6.6561	6.6575	6.6021	6.6309	110868604.0
2009-09-18 11:00:00	AAPL	Stock	6.63	6.6393	6.6136	6.6143	50263584.0
2009-09-18 12:00:00	AAPL	Stock	6.6146	6.6271	6.6021	6.6236	43831368.0
2009-09-18 13:00:00	AAPL	Stock	6.6236	6.6268	6.6132	6.62	36966356.0
2009-09-18 14:00:00	AAPL	Stock	6.6196	6.6339	6.6021	6.6029	50655724.0
2009-09-18 15:00:00	AAPL	Stock	6.6029	6.6161	6.5986	6.6075	91776048.0
2009-09-18 16:00:00	AAPL	Stock	6.6075	6.6274	6.6036	6.6071	18058208.0
2009-09-18 17:00:00	AAPL	Stock	6.6112	6.63	6.6054	6.6064	1207724.0
2009-09-18 18:00:00	AAPL	Stock	6.6064	6.6082	6.6032	6.6054	314860.0
2009-09-18 19:00:00	AAPL	Stock	6.6029	6.6107	6.6025	6.61	73584.0
2009-09-18 08:00:00	MSFT	Stock	25.35	25.37	25.3	25.3	9085.0
2009-09-18 09:00:00	MSFT	Stock	25.3	25.48	25.3	25.39	5018493.0
2009-09-18 10:00:00	MSFT	Stock	25.39	25.4	25.21	25.35	7142350.0
2009-09-18 11:00:00	MSFT	Stock	25.35	25.37	25.22	25.22	3850154.0
2009-09-18 12:00:00	MSFT	Stock	25.22	25.38	25.2	25.38	2896930.0
2009-09-18 13:00:00	MSFT	Stock	25.38	25.42	25.1	25.4	3352827.0
2009-09-18 14:00:00	MSFT	Stock	25.4	25.45	25.33	25.33	3504177.0
2009-09-18 15:00:00	MSFT	Stock	25.33	25.44	25.23	25.26	11022946.0
2009-09-18 16:00:00	MSFT	Stock	25.25	25.375	25.22	25.258	14542506.0
2009-09-18 17:00:00	MSFT	Stock	25.3	25.363	25.183	25.28	80577.0
2009-09-18 19:00:00	MSFT	Stock	25.28	25.39	25.24	25.26	14083.0
2009-09-18 08:00:00	NVDA	Stock	0.3838	0.3838	0.3838	0.3838	20000.0
2009-09-18 09:00:00	NVDA	Stock	0.384	0.3875	0.3822	0.384	130086040.0
2009-09-18 10:00:00	NVDA	Stock	0.3842	0.3858	0.3775	0.3836	104457400.0
2009-09-18 11:00:00	NVDA	Stock	0.3838	0.3848	0.379	0.379	80786600.0
2009-09-18 12:00:00	NVDA	Stock	0.379	0.3803	0.378	0.38	48306040.0
2009-09-18 13:00:00	NVDA	Stock	0.38	0.3801	0.3778	0.3798	58864720.0
2009-09-18 14:00:00	NVDA	Stock	0.38	0.3805	0.3785	0.38	56258320.0
2009-09-18 15:00:00	NVDA	Stock	0.3801	0.3815	0.3793	0.3805	99453280.0
2009-09-18 16:00:00	NVDA	Stock	0.3808	0.3824	0.3801	0.3804	23158200.0
2009-09-18 18:00:00	NVDA	Stock	0.3813	0.3813	0.3813	0.3813	4000.0
2009-09-18 09:00:00	AMZN	Stock	4.5175	4.55	4.484	4.4965	26947060.0
2009-09-18 10:00:00	AMZN	Stock	4.496	4.542	4.4735	4.5315	15775380.0
2009-09-18 11:00:00	AMZN	Stock	4.532	4.535	4.5025	4.5025	11081520.0
2009-09-18 12:00:00	AMZN	Stock	4.503	4.524	4.4918	4.52	10166280.0
2009-09-18 13:00:00	AMZN	Stock	4.52	4.5315	4.514	4.5165	7224260.0
2009-09-18 14:00:00	AMZN	Stock	4.517	4.5325	4.498	4.522	9147840.0
2009-09-18 15:00:00	AMZN	Stock	4.521	4.5305	4.512	4.521	25964760.0
2009-09-18 16:00:00	AMZN	Stock	4.513	4.5215	4.498	4.5139	12397300.0
2009-09-18 17:00:00	AMZN	Stock	4.522	4.5233	4.5	4.5	491120.0
2009-09-18 18:00:00	AMZN	Stock	4.5	4.505	4.499	4.505	20600.0
2009-09-18 08:00:00	TLT	Stock	96.3	96.42	96.23	96.24	15300.0
2009-09-18 09:00:00	TLT	Stock	96.2	96.26	95.91	96.12	484081.0
2009-09-18 10:00:00	TLT	Stock	96.12	96.36	96.02	96.22	274717.0
2009-09-18 11:00:00	TLT	Stock	96.23	96.53	96.23	96.43	282754.0
2009-09-18 12:00:00	TLT	Stock	96.43	96.5201	96.3126	96.37	118085.0

> showing 50 of 43,449 rows — these rows as CSV

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