PREVIEW / stock_30min / 2010-02-10

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-02-10.parquet
  size:    1.3 MB
  rows:    71,514
  symbols: 3,408

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
2010-02-10 05:00:00	AAPL	Stock	7.0161	7.0161	7.0161	7.0161	4004.0
2010-02-10 05:30:00	AAPL	Stock	7.0318	7.0339	7.0318	7.0339	17584.0
2010-02-10 06:30:00	AAPL	Stock	7.0393	7.0393	7.0393	7.0393	28000.0
2010-02-10 07:00:00	AAPL	Stock	7.02	7.02	7.0179	7.0179	8400.0
2010-02-10 07:30:00	AAPL	Stock	7.0421	7.0514	7.0304	7.0339	188216.0
2010-02-10 08:00:00	AAPL	Stock	7.0271	7.0271	6.9968	7.0139	1159648.0
2010-02-10 08:30:00	AAPL	Stock	7.0164	7.0193	7.0039	7.0118	282520.0
2010-02-10 09:00:00	AAPL	Stock	7.0079	7.0179	6.9932	6.9943	894964.0
2010-02-10 09:30:00	AAPL	Stock	6.9961	7.0214	6.9718	6.9936	49870772.0
2010-02-10 10:00:00	AAPL	Stock	6.9936	6.9971	6.9412	6.9541	54120528.0
2010-02-10 10:30:00	AAPL	Stock	6.9543	6.9689	6.9379	6.9589	26478256.0
2010-02-10 11:00:00	AAPL	Stock	6.96	6.9796	6.9507	6.9757	22552096.0
2010-02-10 11:30:00	AAPL	Stock	6.9762	6.9818	6.9582	6.9679	21107800.0
2010-02-10 12:00:00	AAPL	Stock	6.9686	6.9911	6.9561	6.9907	20825252.0
2010-02-10 12:30:00	AAPL	Stock	6.9893	7.0011	6.9821	6.9964	20441764.0
2010-02-10 13:00:00	AAPL	Stock	6.9954	7.0189	6.9882	7.0179	22059212.0
2010-02-10 13:30:00	AAPL	Stock	7.0168	7.0179	6.9904	6.9936	17532872.0
2010-02-10 14:00:00	AAPL	Stock	6.9946	7.0068	6.9893	6.9964	16235800.0
2010-02-10 14:30:00	AAPL	Stock	6.9979	6.9986	6.9711	6.9821	18816112.0
2010-02-10 15:00:00	AAPL	Stock	6.9814	6.9946	6.9786	6.9868	17435768.0
2010-02-10 15:30:00	AAPL	Stock	6.9868	7.0014	6.9582	6.9732	42693000.0
2010-02-10 16:00:00	AAPL	Stock	6.9741	6.9993	6.9671	6.9714	9583840.0
2010-02-10 16:30:00	AAPL	Stock	6.9874	6.9874	6.9671	6.97	380240.0
2010-02-10 17:00:00	AAPL	Stock	6.9714	6.9714	6.97	6.9714	44800.0
2010-02-10 17:30:00	AAPL	Stock	6.9718	6.9721	6.9704	6.9707	36960.0
2010-02-10 18:00:00	AAPL	Stock	6.9732	6.9732	6.9661	6.9679	165620.0
2010-02-10 18:30:00	AAPL	Stock	6.9714	6.9714	6.9714	6.9714	8400.0
2010-02-10 19:00:00	AAPL	Stock	6.9679	6.9771	6.9679	6.9746	437108.0
2010-02-10 19:30:00	AAPL	Stock	6.9696	6.9839	6.9696	6.9839	210392.0
2010-02-10 20:00:00	AAPL	Stock	7.0068	7.0068	7.0068	7.0068	238000.0
2010-02-10 07:30:00	MSFT	Stock	28.15	28.15	28.06	28.06	800.0
2010-02-10 08:00:00	MSFT	Stock	28.06	28.11	27.97	28.02	2850.0
2010-02-10 08:30:00	MSFT	Stock	28.02	28.05	27.95	27.98	7715.0
2010-02-10 09:00:00	MSFT	Stock	28.03	28.08	27.97	28.01	67706.0
2010-02-10 09:30:00	MSFT	Stock	28.03	28.24	27.9	28.19	5999686.0
2010-02-10 10:00:00	MSFT	Stock	28.19	28.2	27.95	28.03	7290904.0
2010-02-10 10:30:00	MSFT	Stock	28.03	28.1	27.96	28.03	3799324.0
2010-02-10 11:00:00	MSFT	Stock	28.03	28.05	27.94	28.03	2806893.0
2010-02-10 11:30:00	MSFT	Stock	28.03	28.04	27.87	27.9	3721935.0
2010-02-10 12:00:00	MSFT	Stock	27.9	28.08	27.84	28.07	3929569.0
2010-02-10 12:30:00	MSFT	Stock	28.07	28.14	28.05	28.07	1525466.0
2010-02-10 13:00:00	MSFT	Stock	28.06	28.12	28.03	28.11	2430421.0
2010-02-10 13:30:00	MSFT	Stock	28.11	28.12	28.05	28.08	1826758.0
2010-02-10 14:00:00	MSFT	Stock	28.09	28.12	28.01	28.06	1626873.0
2010-02-10 14:30:00	MSFT	Stock	28.06	28.06	27.97	28.02	1754445.0
2010-02-10 15:00:00	MSFT	Stock	28.02	28.04	27.96	27.989	2618569.0
2010-02-10 15:30:00	MSFT	Stock	27.98	28.0	27.9	27.99	6744723.0
2010-02-10 16:00:00	MSFT	Stock	28.0	28.07	27.94	27.99	1311151.0
2010-02-10 16:30:00	MSFT	Stock	27.99	28.01	27.99	28.01	37000.0
2010-02-10 17:30:00	MSFT	Stock	27.95	28.0	27.95	28.0	600.0

> showing 50 of 71,514 rows — these rows as CSV

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