PREVIEW / stock_30min / 2010-02-09

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-02-09.parquet
  size:    1.4 MB
  rows:    74,854
  symbols: 3,434

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-09 04:00:00	AAPL	Stock	6.9361	6.9682	6.9361	6.9682	9100.0
2010-02-09 04:30:00	AAPL	Stock	6.9961	6.9961	6.9961	6.9961	2800.0
2010-02-09 05:30:00	AAPL	Stock	6.9657	6.9657	6.9657	6.9657	14000.0
2010-02-09 06:00:00	AAPL	Stock	6.9793	6.9793	6.9793	6.9793	3640.0
2010-02-09 07:00:00	AAPL	Stock	6.9611	6.9921	6.9607	6.9921	469616.0
2010-02-09 07:30:00	AAPL	Stock	6.9893	6.9925	6.975	6.9861	245000.0
2010-02-09 08:00:00	AAPL	Stock	6.9821	7.0179	6.9764	7.0179	2560852.0
2010-02-09 08:30:00	AAPL	Stock	7.0143	7.0321	7.0121	7.0286	2187192.0
2010-02-09 09:00:00	AAPL	Stock	7.0293	7.0296	6.9986	7.0143	2213036.0
2010-02-09 09:30:00	AAPL	Stock	7.0107	7.035	6.9875	7.0096	70477932.0
2010-02-09 10:00:00	AAPL	Stock	7.0096	7.0443	6.9932	7.0339	48307700.0
2010-02-09 10:30:00	AAPL	Stock	7.0339	7.0429	6.9964	7.0011	39702796.0
2010-02-09 11:00:00	AAPL	Stock	7.0011	7.0014	6.9596	6.9636	54889296.0
2010-02-09 11:30:00	AAPL	Stock	6.9639	7.0321	6.9554	7.02	56013104.0
2010-02-09 12:00:00	AAPL	Stock	7.0196	7.0536	7.0161	7.0386	48090364.0
2010-02-09 12:30:00	AAPL	Stock	7.0393	7.0464	6.9925	7.0239	43178072.0
2010-02-09 13:00:00	AAPL	Stock	7.0239	7.0357	7.0071	7.0157	17485244.0
2010-02-09 13:30:00	AAPL	Stock	7.0146	7.0382	7.0082	7.0279	17607548.0
2010-02-09 14:00:00	AAPL	Stock	7.0282	7.0336	7.0036	7.0229	16524872.0
2010-02-09 14:30:00	AAPL	Stock	7.0214	7.0357	7.0	7.0039	26829236.0
2010-02-09 15:00:00	AAPL	Stock	7.0043	7.0286	7.0021	7.0254	27514704.0
2010-02-09 15:30:00	AAPL	Stock	7.0254	7.0307	7.0018	7.0068	53905348.0
2010-02-09 16:00:00	AAPL	Stock	7.0068	7.0196	6.9886	7.0046	8350636.0
2010-02-09 16:30:00	AAPL	Stock	7.0256	7.0256	7.0	7.0036	1143744.0
2010-02-09 17:00:00	AAPL	Stock	7.0036	7.0089	7.0036	7.0054	93772.0
2010-02-09 17:30:00	AAPL	Stock	7.0082	7.0082	7.0036	7.0054	129276.0
2010-02-09 18:00:00	AAPL	Stock	7.0071	7.0071	7.0054	7.0057	175980.0
2010-02-09 18:30:00	AAPL	Stock	7.0071	7.0082	7.0071	7.0082	36400.0
2010-02-09 19:00:00	AAPL	Stock	7.0096	7.0121	7.0096	7.0118	47600.0
2010-02-09 19:30:00	AAPL	Stock	7.0107	7.0118	7.0107	7.0111	78876.0
2010-02-09 07:00:00	MSFT	Stock	27.89	27.92	27.85	27.85	2000.0
2010-02-09 07:30:00	MSFT	Stock	27.92	27.93	27.92	27.92	1800.0
2010-02-09 08:00:00	MSFT	Stock	27.9	27.96	27.82	27.9	15825.0
2010-02-09 08:30:00	MSFT	Stock	27.92	27.95	27.89	27.89	12298.0
2010-02-09 09:00:00	MSFT	Stock	27.92	27.97	27.86	27.97	15909.0
2010-02-09 09:30:00	MSFT	Stock	27.97	28.075	27.9	28.02	4126328.0
2010-02-09 10:00:00	MSFT	Stock	28.005	28.14	27.96	28.06	4542988.0
2010-02-09 10:30:00	MSFT	Stock	28.06	28.14	28.01	28.03	3513250.0
2010-02-09 11:00:00	MSFT	Stock	28.025	28.03	27.75	27.78	6237240.0
2010-02-09 11:30:00	MSFT	Stock	27.78	28.1	27.75	28.04	5331402.0
2010-02-09 12:00:00	MSFT	Stock	28.04	28.34	28.02	28.271	4894013.0
2010-02-09 12:30:00	MSFT	Stock	28.278	28.31	28.05	28.191	5073626.0
2010-02-09 13:00:00	MSFT	Stock	28.19	28.25	28.12	28.16	1815354.0
2010-02-09 13:30:00	MSFT	Stock	28.16	28.2	28.1	28.13	1995660.0
2010-02-09 14:00:00	MSFT	Stock	28.14	28.19	28.09	28.12	1964358.0
2010-02-09 14:30:00	MSFT	Stock	28.13	28.2	28.02	28.095	3145773.0
2010-02-09 15:00:00	MSFT	Stock	28.09	28.15	28.07	28.11	4434752.0
2010-02-09 15:30:00	MSFT	Stock	28.11	28.16	27.95	28.01	6755990.0
2010-02-09 16:00:00	MSFT	Stock	28.01	28.097	27.93	28.01	3169822.0
2010-02-09 16:30:00	MSFT	Stock	28.125	28.125	28.01	28.02	248115.0

> showing 50 of 74,854 rows — these rows as CSV

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