PREVIEW / etf_30min / 2010-01-19

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-01-19.parquet
  size:    247 KB
  rows:    8,340

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-01-19 04:00:00	SPY	ETF	113.69	113.69	113.67	113.67	212.0
2010-01-19 04:30:00	SPY	ETF	113.61	113.61	113.49	113.52	5322.0
2010-01-19 05:00:00	SPY	ETF	113.64	113.64	113.64	113.64	5800.0
2010-01-19 05:30:00	SPY	ETF	113.66	113.66	113.55	113.55	11490.0
2010-01-19 06:00:00	SPY	ETF	113.55	113.57	113.49	113.5	11100.0
2010-01-19 06:30:00	SPY	ETF	113.5	113.51	113.35	113.36	12725.0
2010-01-19 07:00:00	SPY	ETF	113.54	113.54	113.37	113.39	75200.0
2010-01-19 07:30:00	SPY	ETF	113.42	113.46	113.36	113.38	335617.0
2010-01-19 08:00:00	SPY	ETF	113.38	113.68	113.08	113.54	3993631.0
2010-01-19 08:30:00	SPY	ETF	113.53	113.72	113.52	113.52	1679308.0
2010-01-19 09:00:00	SPY	ETF	113.52	113.64	113.5	113.6	1109261.0
2010-01-19 09:30:00	SPY	ETF	113.62	114.33	113.59	114.2	23759639.0
2010-01-19 10:00:00	SPY	ETF	114.2	114.55	114.0	114.41	15204435.0
2010-01-19 10:30:00	SPY	ETF	114.4	114.72	114.4	114.61	10351287.0
2010-01-19 11:00:00	SPY	ETF	114.61	114.62	114.5	114.56	7120378.0
2010-01-19 11:30:00	SPY	ETF	114.55	114.6	114.48	114.53	6015460.0
2010-01-19 12:00:00	SPY	ETF	114.53	114.86	114.52	114.795	8072346.0
2010-01-19 12:30:00	SPY	ETF	114.8	114.95	114.78	114.84	4123251.0
2010-01-19 13:00:00	SPY	ETF	114.84	114.9	114.74	114.83	5031049.0
2010-01-19 13:30:00	SPY	ETF	114.8299	114.87	114.77	114.86	3187315.0
2010-01-19 14:00:00	SPY	ETF	114.86	114.94	114.8	114.9	6962563.0
2010-01-19 14:30:00	SPY	ETF	114.9	114.91	114.82	114.859	4672833.0
2010-01-19 15:00:00	SPY	ETF	114.86	115.09	114.76	115.07	9161626.0
2010-01-19 15:30:00	SPY	ETF	115.06	115.13	114.8733	115.06	16413377.0
2010-01-19 16:00:00	SPY	ETF	115.07	115.1088	113.677	114.92	7101106.0
2010-01-19 16:30:00	SPY	ETF	114.93	114.95	114.82	114.88	531258.0
2010-01-19 17:00:00	SPY	ETF	114.89	114.94	114.86	114.89	93998.0
2010-01-19 17:30:00	SPY	ETF	114.89	114.95	114.87	114.88	46830.0
2010-01-19 18:00:00	SPY	ETF	114.89	114.92	114.86	114.88	173357.0
2010-01-19 18:30:00	SPY	ETF	114.9	114.9	114.83	114.88	32228.0
2010-01-19 19:00:00	SPY	ETF	114.88	114.9	114.85	114.9	17762.0
2010-01-19 19:30:00	SPY	ETF	114.92	115.14	114.89	115.1	274898.0
2010-01-19 20:00:00	SPY	ETF	115.13	115.13	115.13	115.13	2500.0
2010-01-19 04:00:00	QQQ	ETF	45.98	46.0	45.93	45.93	2500.0
2010-01-19 04:30:00	QQQ	ETF	45.93	45.93	45.85	45.88	3583.0
2010-01-19 05:00:00	QQQ	ETF	45.92	45.94	45.92	45.94	1200.0
2010-01-19 05:30:00	QQQ	ETF	45.92	45.92	45.9	45.9	20400.0
2010-01-19 06:00:00	QQQ	ETF	45.89	45.9	45.85	45.85	22000.0
2010-01-19 06:30:00	QQQ	ETF	45.81	45.82	45.81	45.82	3100.0
2010-01-19 07:00:00	QQQ	ETF	45.83	45.83	45.83	45.83	15000.0
2010-01-19 07:30:00	QQQ	ETF	45.84	45.87	45.81	45.82	119407.0
2010-01-19 08:00:00	QQQ	ETF	45.8	45.94	45.71	45.92	1211695.0
2010-01-19 08:30:00	QQQ	ETF	45.93	46.02	45.9	45.91	595862.0
2010-01-19 09:00:00	QQQ	ETF	45.9	46.13	45.9	45.95	389178.0
2010-01-19 09:30:00	QQQ	ETF	45.95	46.32	45.95	46.25	14329228.0
2010-01-19 10:00:00	QQQ	ETF	46.25	46.5	46.245	46.3601	12527722.0
2010-01-19 10:30:00	QQQ	ETF	46.36	46.5	46.36	46.4599	6256012.0
2010-01-19 11:00:00	QQQ	ETF	46.45	46.48	46.43	46.45	2951190.0
2010-01-19 11:30:00	QQQ	ETF	46.46	46.48	46.38	46.41	3103626.0
2010-01-19 12:00:00	QQQ	ETF	46.41	46.55	46.41	46.52	3214644.0

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

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