PREVIEW / etf_30min / 2010-06-17

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-06-17.parquet
  size:    250 KB
  rows:    8,200

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-17 04:00:00	SPY	ETF	111.7	111.79	111.7	111.79	1600.0
2010-06-17 04:30:00	SPY	ETF	111.82	112.02	111.82	111.85	10500.0
2010-06-17 05:00:00	SPY	ETF	111.88	112.22	111.87	112.22	1000.0
2010-06-17 05:30:00	SPY	ETF	112.25	112.34	112.25	112.31	5600.0
2010-06-17 06:00:00	SPY	ETF	112.31	112.31	112.19	112.21	6575.0
2010-06-17 06:30:00	SPY	ETF	112.24	112.32	112.19	112.3	12105.0
2010-06-17 07:00:00	SPY	ETF	112.31	112.48	112.3	112.46	297719.0
2010-06-17 07:30:00	SPY	ETF	112.43	112.49	112.38	112.4	159723.0
2010-06-17 08:00:00	SPY	ETF	112.39	112.55	112.0	112.47	2200871.0
2010-06-17 08:30:00	SPY	ETF	112.46	112.72	111.99	112.24	3290270.0
2010-06-17 09:00:00	SPY	ETF	112.23	112.43	112.15	112.28	1574908.0
2010-06-17 09:30:00	SPY	ETF	112.28	112.33	111.8	112.099	23396743.0
2010-06-17 10:00:00	SPY	ETF	112.09	112.2	111.23	111.4	31851353.0
2010-06-17 10:30:00	SPY	ETF	111.4	111.42	111.1	111.3	18278151.0
2010-06-17 11:00:00	SPY	ETF	111.3	111.61	111.05	111.53	14148721.0
2010-06-17 11:30:00	SPY	ETF	111.52	111.78	111.51	111.7	25690113.0
2010-06-17 12:00:00	SPY	ETF	111.69	111.8	111.47	111.53	9729793.0
2010-06-17 12:30:00	SPY	ETF	111.53	111.65	111.32	111.54	6032286.0
2010-06-17 13:00:00	SPY	ETF	111.54	111.73	111.38	111.63	9266646.0
2010-06-17 13:30:00	SPY	ETF	111.63	111.96	111.51	111.93	7888049.0
2010-06-17 14:00:00	SPY	ETF	111.93	112.02	111.7	111.71	10375135.0
2010-06-17 14:30:00	SPY	ETF	111.7099	111.83	111.46	111.62	12965956.0
2010-06-17 15:00:00	SPY	ETF	111.62	111.62	111.2	111.27	17719218.0
2010-06-17 15:30:00	SPY	ETF	111.28	112.22	111.27	112.12	41801122.0
2010-06-17 16:00:00	SPY	ETF	112.13	112.24	111.22	112.16	19967017.0
2010-06-17 16:30:00	SPY	ETF	112.15	112.17	112.0387	112.13	4845590.0
2010-06-17 17:00:00	SPY	ETF	112.11	112.18	112.05	112.08	478319.0
2010-06-17 17:30:00	SPY	ETF	112.05	112.17	112.03	112.14	154100.0
2010-06-17 18:00:00	SPY	ETF	112.14	112.16	112.0	112.01	96764.0
2010-06-17 18:30:00	SPY	ETF	112.05	112.07	112.01	112.01	21415.0
2010-06-17 19:00:00	SPY	ETF	112.06	112.1	112.04	112.04	7750.0
2010-06-17 19:30:00	SPY	ETF	112.06	112.09	112.05	112.06	17194.0
2010-06-17 04:00:00	QQQ	ETF	46.85	46.85	46.84	46.84	17695.0
2010-06-17 04:30:00	QQQ	ETF	46.95	46.95	46.95	46.95	17695.0
2010-06-17 05:00:00	QQQ	ETF	47.07	47.09	47.07	47.09	13100.0
2010-06-17 05:30:00	QQQ	ETF	47.1	47.14	47.1	47.14	3900.0
2010-06-17 06:00:00	QQQ	ETF	47.14	47.14	47.1	47.1	14000.0
2010-06-17 06:30:00	QQQ	ETF	47.1	47.14	47.07	47.12	53622.0
2010-06-17 07:00:00	QQQ	ETF	47.12	47.19	47.12	47.18	171175.0
2010-06-17 07:30:00	QQQ	ETF	47.19	47.23	47.16	47.2	144819.0
2010-06-17 08:00:00	QQQ	ETF	47.18	47.23	47.12	47.18	1622038.0
2010-06-17 08:30:00	QQQ	ETF	47.17	47.25	47.02	47.14	1761378.0
2010-06-17 09:00:00	QQQ	ETF	47.14	47.22	47.09	47.14	423057.0
2010-06-17 09:30:00	QQQ	ETF	47.16	47.18	46.91	47.1325	9761612.0
2010-06-17 10:00:00	QQQ	ETF	47.14	47.14	46.68	46.74	11543001.0
2010-06-17 10:30:00	QQQ	ETF	46.75	46.84	46.64	46.79	5889520.0
2010-06-17 11:00:00	QQQ	ETF	46.79	46.93	46.66	46.88	3885109.0
2010-06-17 11:30:00	QQQ	ETF	46.88	47.04	46.87	47.01	4027910.0
2010-06-17 12:00:00	QQQ	ETF	47.01	47.02	46.87	46.89	2248080.0
2010-06-17 12:30:00	QQQ	ETF	46.88	46.93	46.812	46.89	1350690.0

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

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