PREVIEW / stock_30min / 2011-01-03

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-01-03.parquet
  size:    1.5 MB
  rows:    78,756
  symbols: 3,538

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
2011-01-03 04:00:00	AAPL	Stock	11.5714	11.5929	11.5714	11.5929	29680.0
2011-01-03 04:30:00	AAPL	Stock	11.5968	11.5968	11.5968	11.5968	5600.0
2011-01-03 05:00:00	AAPL	Stock	11.6064	11.6064	11.6064	11.6064	2800.0
2011-01-03 05:30:00	AAPL	Stock	11.6371	11.6371	11.6096	11.6096	14000.0
2011-01-03 06:00:00	AAPL	Stock	11.6339	11.6339	11.62	11.62	5600.0
2011-01-03 06:30:00	AAPL	Stock	11.6236	11.6236	11.6229	11.6229	8400.0
2011-01-03 07:00:00	AAPL	Stock	11.6143	11.6214	11.5846	11.6	218400.0
2011-01-03 07:30:00	AAPL	Stock	11.6007	11.6321	11.6004	11.6321	295344.0
2011-01-03 08:00:00	AAPL	Stock	11.6182	11.6329	11.5996	11.6071	1311268.0
2011-01-03 08:30:00	AAPL	Stock	11.52	11.6071	11.52	11.6	977760.0
2011-01-03 09:00:00	AAPL	Stock	11.6007	11.6296	11.52	11.6296	1749748.0
2011-01-03 09:30:00	AAPL	Stock	11.63	11.7096	11.6013	11.6954	82623996.0
2011-01-03 10:00:00	AAPL	Stock	11.6952	11.7839	11.6918	11.7532	68683552.0
2011-01-03 10:30:00	AAPL	Stock	11.7532	11.785	11.7461	11.7825	33519640.0
2011-01-03 11:00:00	AAPL	Stock	11.7836	11.7875	11.7593	11.7807	32297524.0
2011-01-03 11:30:00	AAPL	Stock	11.7806	11.7929	11.7664	11.7756	26893076.0
2011-01-03 12:00:00	AAPL	Stock	11.7754	11.7804	11.7679	11.7743	16503228.0
2011-01-03 12:30:00	AAPL	Stock	11.7743	11.7779	11.7614	11.7696	13016304.0
2011-01-03 13:00:00	AAPL	Stock	11.7694	11.7775	11.7643	11.7768	11949700.0
2011-01-03 13:30:00	AAPL	Stock	11.7763	11.7854	11.7757	11.7839	12943224.0
2011-01-03 14:00:00	AAPL	Stock	11.7839	11.795	11.7589	11.7611	23222864.0
2011-01-03 14:30:00	AAPL	Stock	11.7621	11.7743	11.7393	11.7686	25229680.0
2011-01-03 15:00:00	AAPL	Stock	11.7689	11.7696	11.7246	11.7454	28152656.0
2011-01-03 15:30:00	AAPL	Stock	11.7461	11.7757	11.7411	11.7757	43592976.0
2011-01-03 16:00:00	AAPL	Stock	11.7757	11.7761	11.744	11.7696	15385944.0
2011-01-03 16:30:00	AAPL	Stock	11.7696	11.7775	11.746	11.7664	841960.0
2011-01-03 17:00:00	AAPL	Stock	11.7679	11.7761	11.7679	11.7761	611352.0
2011-01-03 17:30:00	AAPL	Stock	11.7696	11.7696	11.7682	11.7689	55720.0
2011-01-03 18:00:00	AAPL	Stock	11.7679	11.775	11.7679	11.775	290052.0
2011-01-03 18:30:00	AAPL	Stock	11.7743	11.7818	11.7714	11.7771	150556.0
2011-01-03 19:00:00	AAPL	Stock	11.7782	11.7793	11.7782	11.7782	47152.0
2011-01-03 19:30:00	AAPL	Stock	11.7768	11.7782	11.7714	11.7714	202496.0
2011-01-03 04:00:00	MSFT	Stock	28.04	28.04	28.04	28.04	100.0
2011-01-03 07:00:00	MSFT	Stock	28.1	28.1	28.1	28.1	1000.0
2011-01-03 07:30:00	MSFT	Stock	28.07	28.07	28.05	28.05	1600.0
2011-01-03 08:00:00	MSFT	Stock	28.05	28.14	27.92	28.14	49347.0
2011-01-03 08:30:00	MSFT	Stock	28.11	28.14	28.1	28.1	10013.0
2011-01-03 09:00:00	MSFT	Stock	28.1	28.15	27.92	28.03	85007.0
2011-01-03 09:30:00	MSFT	Stock	28.03	28.18	28.02	28.11	7127158.0
2011-01-03 10:00:00	MSFT	Stock	28.12	28.13	28.06	28.1	4831774.0
2011-01-03 10:30:00	MSFT	Stock	28.1	28.13	28.07	28.1	4039703.0
2011-01-03 11:00:00	MSFT	Stock	28.1	28.12	27.97	28.1	3765667.0
2011-01-03 11:30:00	MSFT	Stock	28.1	28.12	28.02	28.041	2780352.0
2011-01-03 12:00:00	MSFT	Stock	28.05	28.09	28.02	28.03	2661845.0
2011-01-03 12:30:00	MSFT	Stock	28.03	28.05	27.99	28.03	1848739.0
2011-01-03 13:00:00	MSFT	Stock	28.021	28.04	27.98	28.0	1885619.0
2011-01-03 13:30:00	MSFT	Stock	27.992	28.01	27.97	28.0	1354341.0
2011-01-03 14:00:00	MSFT	Stock	28.0	28.01	27.97	27.977	1909252.0
2011-01-03 14:30:00	MSFT	Stock	27.97	28.0	27.94	27.98	2184785.0
2011-01-03 15:00:00	MSFT	Stock	27.99	28.06	27.95	28.041	4125994.0

> showing 50 of 78,756 rows — these rows as CSV

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