PREVIEW / stock_30min / 2010-04-26

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-04-26.parquet
  size:    1.4 MB
  rows:    76,410
  symbols: 3,510

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-04-26 04:00:00	AAPL	Stock	9.7143	9.7143	9.7143	9.7143	5600.0
2010-04-26 04:30:00	AAPL	Stock	9.7143	9.7143	9.7143	9.7143	5600.0
2010-04-26 05:00:00	AAPL	Stock	9.7143	9.7143	9.7143	9.7143	5600.0
2010-04-26 05:30:00	AAPL	Stock	9.7143	9.7143	9.7143	9.7143	37548.0
2010-04-26 06:00:00	AAPL	Stock	9.7221	9.7232	9.7221	9.7232	16800.0
2010-04-26 06:30:00	AAPL	Stock	9.725	9.7286	9.7179	9.7286	27776.0
2010-04-26 07:00:00	AAPL	Stock	9.7321	9.7411	9.7296	9.7296	206500.0
2010-04-26 07:30:00	AAPL	Stock	9.7371	9.7429	9.7286	9.7321	110320.0
2010-04-26 08:00:00	AAPL	Stock	9.7321	9.7321	9.6914	9.7143	2524480.0
2010-04-26 08:30:00	AAPL	Stock	9.7171	9.7189	9.6986	9.7136	1488452.0
2010-04-26 09:00:00	AAPL	Stock	9.7107	9.7218	9.7054	9.7082	778512.0
2010-04-26 09:30:00	AAPL	Stock	9.71	9.7307	9.5843	9.595	114736692.0
2010-04-26 10:00:00	AAPL	Stock	9.5966	9.6536	9.595	9.6204	51060240.0
2010-04-26 10:30:00	AAPL	Stock	9.6207	9.6529	9.6036	9.647	38270904.0
2010-04-26 11:00:00	AAPL	Stock	9.6471	9.6721	9.625	9.6414	30538984.0
2010-04-26 11:30:00	AAPL	Stock	9.6414	9.6486	9.6196	9.6225	18120256.0
2010-04-26 12:00:00	AAPL	Stock	9.6225	9.6257	9.605	9.6093	22749524.0
2010-04-26 12:30:00	AAPL	Stock	9.6093	9.625	9.6036	9.6246	18149152.0
2010-04-26 13:00:00	AAPL	Stock	9.6244	9.6379	9.6214	9.6232	14751492.0
2010-04-26 13:30:00	AAPL	Stock	9.625	9.6275	9.6107	9.6211	17217480.0
2010-04-26 14:00:00	AAPL	Stock	9.6221	9.6418	9.6061	9.6375	18151056.0
2010-04-26 14:30:00	AAPL	Stock	9.6357	9.6411	9.6089	9.6093	17140004.0
2010-04-26 15:00:00	AAPL	Stock	9.6093	9.6725	9.5782	9.5964	38095764.0
2010-04-26 15:30:00	AAPL	Stock	9.5971	9.625	9.5964	9.625	41670356.0
2010-04-26 16:00:00	AAPL	Stock	9.6243	9.6446	9.6075	9.612	21640220.0
2010-04-26 16:30:00	AAPL	Stock	9.6073	9.625	9.6073	9.6179	3874080.0
2010-04-26 17:00:00	AAPL	Stock	9.6196	9.625	9.6125	9.6125	312340.0
2010-04-26 17:30:00	AAPL	Stock	9.6127	9.6175	9.6125	9.6143	78260.0
2010-04-26 18:00:00	AAPL	Stock	9.6143	9.625	9.6086	9.6093	1131956.0
2010-04-26 18:30:00	AAPL	Stock	9.6125	9.6179	9.6107	9.6179	130312.0
2010-04-26 19:00:00	AAPL	Stock	9.6107	9.6143	9.6107	9.6111	63504.0
2010-04-26 19:30:00	AAPL	Stock	9.6136	9.6171	9.6129	9.6129	90160.0
2010-04-26 06:00:00	MSFT	Stock	30.83	30.83	30.83	30.83	450.0
2010-04-26 07:00:00	MSFT	Stock	30.99	30.99	30.99	30.99	100.0
2010-04-26 07:30:00	MSFT	Stock	30.98	31.0	30.92	31.0	2080.0
2010-04-26 08:00:00	MSFT	Stock	30.96	31.06	30.95	31.04	29555.0
2010-04-26 08:30:00	MSFT	Stock	31.03	31.07	31.0	31.02	56005.0
2010-04-26 09:00:00	MSFT	Stock	31.01	31.02	30.98	31.0	50904.0
2010-04-26 09:30:00	MSFT	Stock	30.99	31.1	30.86	31.03	6936364.0
2010-04-26 10:00:00	MSFT	Stock	31.026	31.05	30.95	31.015	5357488.0
2010-04-26 10:30:00	MSFT	Stock	31.012	31.17	31.0	31.16	3979763.0
2010-04-26 11:00:00	MSFT	Stock	31.15	31.18	31.071	31.14	3130245.0
2010-04-26 11:30:00	MSFT	Stock	31.15	31.17	31.04	31.052	4477595.0
2010-04-26 12:00:00	MSFT	Stock	31.05	31.15	31.01	31.072	3225650.0
2010-04-26 12:30:00	MSFT	Stock	31.08	31.12	31.06	31.12	2219889.0
2010-04-26 13:00:00	MSFT	Stock	31.12	31.13	31.08	31.12	2169340.0
2010-04-26 13:30:00	MSFT	Stock	31.12	31.155	31.1	31.11	3609566.0
2010-04-26 14:00:00	MSFT	Stock	31.105	31.21	31.1	31.2	2648552.0
2010-04-26 14:30:00	MSFT	Stock	31.2	31.24	31.15	31.15	3333483.0
2010-04-26 15:00:00	MSFT	Stock	31.15	31.275	31.135	31.2	5169142.0

> showing 50 of 76,410 rows — these rows as CSV

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