PREVIEW / etf_30min / 2010-06-14

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-06-14.parquet
  size:    256 KB
  rows:    8,436

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-06-14 04:00:00	SPY	ETF	110.06	110.19	110.06	110.13	5300.0
2010-06-14 04:30:00	SPY	ETF	110.27	110.46	110.27	110.46	3800.0
2010-06-14 05:00:00	SPY	ETF	110.42	110.52	110.4	110.52	3700.0
2010-06-14 05:30:00	SPY	ETF	110.43	110.48	110.35	110.48	10700.0
2010-06-14 06:00:00	SPY	ETF	110.32	110.38	110.32	110.35	5550.0
2010-06-14 06:30:00	SPY	ETF	110.35	110.35	110.25	110.25	77687.0
2010-06-14 07:00:00	SPY	ETF	110.25	110.33	110.12	110.13	166165.0
2010-06-14 07:30:00	SPY	ETF	110.15	110.36	110.15	110.35	110795.0
2010-06-14 08:00:00	SPY	ETF	110.32	110.52	110.27	110.37	620959.0
2010-06-14 08:30:00	SPY	ETF	110.37	110.47	110.32	110.4	600524.0
2010-06-14 09:00:00	SPY	ETF	110.39	110.53	110.31	110.53	2017973.0
2010-06-14 09:30:00	SPY	ETF	110.52	110.59	110.11	110.27	22741478.0
2010-06-14 10:00:00	SPY	ETF	110.27	110.71	110.21	110.6	14733994.0
2010-06-14 10:30:00	SPY	ETF	110.61	110.75	110.36	110.72	11234958.0
2010-06-14 11:00:00	SPY	ETF	110.72	111.12	110.62	110.89	16491981.0
2010-06-14 11:30:00	SPY	ETF	110.88	110.915	110.73	110.76	8746320.0
2010-06-14 12:00:00	SPY	ETF	110.76	110.92	110.68	110.8	6338775.0
2010-06-14 12:30:00	SPY	ETF	110.8	110.87	110.4	110.4	7514003.0
2010-06-14 13:00:00	SPY	ETF	110.4	110.65	110.2	110.435	16802433.0
2010-06-14 13:30:00	SPY	ETF	110.44	110.68	110.03	110.04	8592708.0
2010-06-14 14:00:00	SPY	ETF	110.04	110.18	109.77	110.1	19981388.0
2010-06-14 14:30:00	SPY	ETF	110.1	110.28	109.78	110.2226	9941246.0
2010-06-14 15:00:00	SPY	ETF	110.22	110.38	109.9	110.02	12877754.0
2010-06-14 15:30:00	SPY	ETF	110.02	110.03	109.4	109.52	32549793.0
2010-06-14 16:00:00	SPY	ETF	109.54	111.0307	109.43	109.57	12420008.0
2010-06-14 16:30:00	SPY	ETF	109.53	109.62	109.51	109.52	2192563.0
2010-06-14 17:00:00	SPY	ETF	109.56	109.62	109.53	109.58	84075.0
2010-06-14 17:30:00	SPY	ETF	109.58	109.58	109.52	109.54	47917.0
2010-06-14 18:00:00	SPY	ETF	109.54	109.63	109.53	109.57	90102.0
2010-06-14 18:30:00	SPY	ETF	109.56	109.66	109.48	109.52	107466.0
2010-06-14 19:00:00	SPY	ETF	109.5	109.57	109.49	109.54	18420.0
2010-06-14 19:30:00	SPY	ETF	109.54	109.6	109.53	109.55	26464.0
2010-06-14 04:00:00	QQQ	ETF	45.72	45.72	45.7	45.7	200.0
2010-06-14 04:30:00	QQQ	ETF	45.78	45.78	45.78	45.78	190.0
2010-06-14 05:00:00	QQQ	ETF	45.8	45.82	45.8	45.8	2200.0
2010-06-14 05:30:00	QQQ	ETF	45.81	45.81	45.81	45.81	100.0
2010-06-14 06:30:00	QQQ	ETF	45.74	45.74	45.73	45.73	300.0
2010-06-14 07:00:00	QQQ	ETF	45.71	45.73	45.67	45.67	14500.0
2010-06-14 07:30:00	QQQ	ETF	45.72	45.79	45.72	45.77	40959.0
2010-06-14 08:00:00	QQQ	ETF	45.77	45.88	45.73	45.83	277574.0
2010-06-14 08:30:00	QQQ	ETF	45.84	45.87	45.48	45.85	250002.0
2010-06-14 09:00:00	QQQ	ETF	45.85	45.91	45.8	45.91	356437.0
2010-06-14 09:30:00	QQQ	ETF	45.9	46.04	45.81	45.93	7831184.0
2010-06-14 10:00:00	QQQ	ETF	45.93	46.16	45.92	46.13	4707952.0
2010-06-14 10:30:00	QQQ	ETF	46.13	46.14	46.01	46.1	3241539.0
2010-06-14 11:00:00	QQQ	ETF	46.1	46.24	46.06	46.14	4202564.0
2010-06-14 11:30:00	QQQ	ETF	46.14	46.1719	46.07	46.07	3091898.0
2010-06-14 12:00:00	QQQ	ETF	46.08	46.155	46.02	46.06	1783290.0
2010-06-14 12:30:00	QQQ	ETF	46.06	46.09	45.92	45.92	2436940.0
2010-06-14 13:00:00	QQQ	ETF	45.92	46.0	45.84	45.91	7128972.0

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

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