PREVIEW / etf_30min / 2010-03-15

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-03-15.parquet
  size:    245 KB
  rows:    8,103

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-03-15 04:00:00	SPY	ETF	115.3	115.3	115.3	115.3	100.0
2010-03-15 04:30:00	SPY	ETF	115.15	115.15	115.15	115.15	100.0
2010-03-15 05:00:00	SPY	ETF	115.12	115.12	115.09	115.09	1800.0
2010-03-15 06:30:00	SPY	ETF	115.16	115.16	115.13	115.13	27100.0
2010-03-15 07:00:00	SPY	ETF	115.15	115.29	115.15	115.29	111670.0
2010-03-15 07:30:00	SPY	ETF	115.29	115.3	115.25	115.3	43500.0
2010-03-15 08:00:00	SPY	ETF	115.18	115.35	114.88	115.34	861863.0
2010-03-15 08:30:00	SPY	ETF	115.34	115.4	115.28	115.33	306796.0
2010-03-15 09:00:00	SPY	ETF	115.33	115.33	115.21	115.25	643487.0
2010-03-15 09:30:00	SPY	ETF	115.26	115.4825	115.11	115.138	14284361.0
2010-03-15 10:00:00	SPY	ETF	115.13	115.35	115.02	115.24	12274044.0
2010-03-15 10:30:00	SPY	ETF	115.25	115.29	115.05	115.12	8320207.0
2010-03-15 11:00:00	SPY	ETF	115.11	115.18	114.6	114.765	17455430.0
2010-03-15 11:30:00	SPY	ETF	114.76	114.95	114.64	114.79	8394557.0
2010-03-15 12:00:00	SPY	ETF	114.788	114.87	114.65	114.8	6857193.0
2010-03-15 12:30:00	SPY	ETF	114.8	114.94	114.75	114.88	6394770.0
2010-03-15 13:00:00	SPY	ETF	114.88	114.94	114.84	114.87	5967790.0
2010-03-15 13:30:00	SPY	ETF	114.88	115.02	114.87	114.98	6083753.0
2010-03-15 14:00:00	SPY	ETF	114.98	114.98	114.82	114.9016	6700055.0
2010-03-15 14:30:00	SPY	ETF	114.91	115.15	114.77	115.075	9566048.0
2010-03-15 15:00:00	SPY	ETF	115.06	115.37	115.05	115.34	10992202.0
2010-03-15 15:30:00	SPY	ETF	115.345	115.575	114.8	115.5	17162982.0
2010-03-15 16:00:00	SPY	ETF	115.51	115.55	115.06	115.5	6366689.0
2010-03-15 16:30:00	SPY	ETF	115.5	115.65	115.4699	115.54	5720695.0
2010-03-15 17:00:00	SPY	ETF	115.56	115.63	115.55	115.63	152048.0
2010-03-15 17:30:00	SPY	ETF	115.62	115.63	115.58	115.59	9139.0
2010-03-15 18:00:00	SPY	ETF	115.62	115.66	115.5	115.62	95545.0
2010-03-15 18:30:00	SPY	ETF	115.62	115.62	115.52	115.55	15794.0
2010-03-15 19:00:00	SPY	ETF	115.58	115.58	115.54	115.55	20257.0
2010-03-15 19:30:00	SPY	ETF	115.55	115.61	115.55	115.58	153329.0
2010-03-15 06:30:00	QQQ	ETF	47.27	47.27	47.26	47.26	17000.0
2010-03-15 07:00:00	QQQ	ETF	47.25	47.32	47.25	47.32	5196.0
2010-03-15 07:30:00	QQQ	ETF	47.3	47.32	47.29	47.3	25130.0
2010-03-15 08:00:00	QQQ	ETF	47.31	47.32	47.29	47.32	126229.0
2010-03-15 08:30:00	QQQ	ETF	47.32	47.33	47.28	47.28	89570.0
2010-03-15 09:00:00	QQQ	ETF	47.28	47.29	47.23	47.25	629749.0
2010-03-15 09:30:00	QQQ	ETF	47.25	47.38	47.165	47.18	8255684.0
2010-03-15 10:00:00	QQQ	ETF	47.17	47.28	47.13	47.24	5935712.0
2010-03-15 10:30:00	QQQ	ETF	47.232	47.26	47.08	47.1	4479839.0
2010-03-15 11:00:00	QQQ	ETF	47.1	47.15	46.91	46.98	6432214.0
2010-03-15 11:30:00	QQQ	ETF	46.98	47.01	46.93	46.98	2650320.0
2010-03-15 12:00:00	QQQ	ETF	46.98	47.367	46.93	46.98	2462154.0
2010-03-15 12:30:00	QQQ	ETF	46.99	47.04	46.96	47.0	2587630.0
2010-03-15 13:00:00	QQQ	ETF	47.0	47.02	46.96	46.97	1749855.0
2010-03-15 13:30:00	QQQ	ETF	46.9799	47.0301	46.9701	47.01	1204537.0
2010-03-15 14:00:00	QQQ	ETF	47.0	47.02	46.96	46.983	958327.0
2010-03-15 14:30:00	QQQ	ETF	46.9881	47.11	46.92	47.06	2898943.0
2010-03-15 15:00:00	QQQ	ETF	47.064	47.21	47.06	47.2	5377312.0
2010-03-15 15:30:00	QQQ	ETF	47.2	47.29	47.17	47.25	7352055.0
2010-03-15 16:00:00	QQQ	ETF	47.25	47.367	46.96	47.24	3294636.0

> showing 50 of 8,103 rows — these rows as CSV

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