PREVIEW / etf_30min / 2010-06-11

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-06-11.parquet
  size:    243 KB
  rows:    8,001

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-11 04:00:00	SPY	ETF	108.7	108.85	108.7	108.85	580.0
2010-06-11 04:30:00	SPY	ETF	108.81	108.99	108.72	108.99	1900.0
2010-06-11 05:00:00	SPY	ETF	109.03	109.14	109.0	109.14	1225.0
2010-06-11 05:30:00	SPY	ETF	109.09	109.15	109.09	109.15	1600.0
2010-06-11 06:00:00	SPY	ETF	109.13	109.18	109.13	109.15	4250.0
2010-06-11 06:30:00	SPY	ETF	109.07	109.11	108.96	108.96	4400.0
2010-06-11 07:00:00	SPY	ETF	108.96	109.06	108.89	108.91	153615.0
2010-06-11 07:30:00	SPY	ETF	108.91	108.95	108.82	108.93	438929.0
2010-06-11 08:00:00	SPY	ETF	108.93	109.1	108.92	108.94	1250672.0
2010-06-11 08:30:00	SPY	ETF	108.93	108.93	108.0	108.03	4348062.0
2010-06-11 09:00:00	SPY	ETF	108.05	108.21	107.98	108.21	2853450.0
2010-06-11 09:30:00	SPY	ETF	108.19	108.93	108.12	108.9	31883755.0
2010-06-11 10:00:00	SPY	ETF	108.89	109.4	108.71	109.227	22746348.0
2010-06-11 10:30:00	SPY	ETF	109.22	109.38	108.77	108.82	14131829.0
2010-06-11 11:00:00	SPY	ETF	108.801	109.2	108.42	108.68	14386023.0
2010-06-11 11:30:00	SPY	ETF	108.69	109.01	108.58	108.99	11054198.0
2010-06-11 12:00:00	SPY	ETF	108.99	109.02	108.66	108.77	6422317.0
2010-06-11 12:30:00	SPY	ETF	108.765	108.99	108.6	108.87	6025603.0
2010-06-11 13:00:00	SPY	ETF	108.86	109.2	108.86	109.03	6799554.0
2010-06-11 13:30:00	SPY	ETF	109.035	109.1	108.7	108.78	8628607.0
2010-06-11 14:00:00	SPY	ETF	108.79	108.97	108.51	108.64	10248556.0
2010-06-11 14:30:00	SPY	ETF	108.65	109.01	108.6	108.84	8079623.0
2010-06-11 15:00:00	SPY	ETF	108.84	109.14	108.71	109.0	11643210.0
2010-06-11 15:30:00	SPY	ETF	109.0	109.75	108.96	109.66	28252991.0
2010-06-11 16:00:00	SPY	ETF	109.65	109.6867	108.3097	109.5	21203060.0
2010-06-11 16:30:00	SPY	ETF	109.5	109.68	109.1947	109.54	2647049.0
2010-06-11 17:00:00	SPY	ETF	109.52	109.56	109.44	109.45	153810.0
2010-06-11 17:30:00	SPY	ETF	109.48	109.49	109.43	109.46	34312.0
2010-06-11 18:00:00	SPY	ETF	109.45	109.68	109.44	109.5	24035.0
2010-06-11 18:30:00	SPY	ETF	109.48	109.5	109.46	109.47	14064.0
2010-06-11 19:00:00	SPY	ETF	109.48	109.51	109.45	109.46	17472.0
2010-06-11 19:30:00	SPY	ETF	109.47	109.51	109.47	109.51	11380.0
2010-06-11 04:00:00	QQQ	ETF	44.86	44.86	44.86	44.86	398.0
2010-06-11 05:00:00	QQQ	ETF	44.96	45.03	44.96	45.03	1500.0
2010-06-11 06:00:00	QQQ	ETF	44.99	44.99	44.99	44.99	1300.0
2010-06-11 06:30:00	QQQ	ETF	45.04	45.04	45.04	45.04	5000.0
2010-06-11 07:00:00	QQQ	ETF	44.96	44.99	44.93	44.93	59557.0
2010-06-11 07:30:00	QQQ	ETF	44.92	44.95	44.88	44.95	41749.0
2010-06-11 08:00:00	QQQ	ETF	44.93	44.98	44.92	44.95	79974.0
2010-06-11 08:30:00	QQQ	ETF	44.94	44.94	44.4	44.55	1285889.0
2010-06-11 09:00:00	QQQ	ETF	44.55	45.07	44.53	44.64	266310.0
2010-06-11 09:30:00	QQQ	ETF	44.63	45.05	44.61	45.04	11139276.0
2010-06-11 10:00:00	QQQ	ETF	45.04	45.39	44.95	45.29	9472249.0
2010-06-11 10:30:00	QQQ	ETF	45.29	45.36	45.0	45.07	4930319.0
2010-06-11 11:00:00	QQQ	ETF	45.08	45.25	44.83	44.95	5902413.0
2010-06-11 11:30:00	QQQ	ETF	44.9495	45.18	44.9406	45.1599	4334249.0
2010-06-11 12:00:00	QQQ	ETF	45.16	45.18	45.02	45.07	2071400.0
2010-06-11 12:30:00	QQQ	ETF	45.07	45.17	44.99	45.12	2437449.0
2010-06-11 13:00:00	QQQ	ETF	45.12	45.31	45.0	45.19	2855771.0
2010-06-11 13:30:00	QQQ	ETF	45.19	45.22	45.0	45.07	4684615.0

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

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