PREVIEW / etf_30min / 2008-06-16

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-06-16.parquet
  size:    163 KB
  rows:    5,646

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
2008-06-16 04:00:00	SPY	ETF	136.29	136.36	136.29	136.36	900.0
2008-06-16 05:00:00	SPY	ETF	136.5	136.5	136.5	136.5	100.0
2008-06-16 05:30:00	SPY	ETF	136.5	136.59	136.5	136.59	200.0
2008-06-16 06:00:00	SPY	ETF	136.59	136.6	136.53	136.6	24100.0
2008-06-16 06:30:00	SPY	ETF	136.59	136.6	136.5	136.57	30400.0
2008-06-16 07:00:00	SPY	ETF	136.36	136.41	136.17	136.23	499500.0
2008-06-16 07:30:00	SPY	ETF	136.23	136.23	136.0	136.07	483400.0
2008-06-16 08:00:00	SPY	ETF	136.57	136.57	135.99	135.99	1185296.0
2008-06-16 08:30:00	SPY	ETF	135.97	135.98	135.59	135.73	3177264.0
2008-06-16 09:00:00	SPY	ETF	135.75	135.75	135.38	135.56	3528480.0
2008-06-16 09:30:00	SPY	ETF	135.55	135.97	135.46	135.82	20927866.0
2008-06-16 10:00:00	SPY	ETF	135.82	136.29	135.63	136.11	19925373.0
2008-06-16 10:30:00	SPY	ETF	136.12	136.57	135.93	136.52	13415947.0
2008-06-16 11:00:00	SPY	ETF	136.52	136.55	136.03	136.16	13163130.0
2008-06-16 11:30:00	SPY	ETF	136.16	136.4294	136.1	136.22	8168831.0
2008-06-16 12:00:00	SPY	ETF	136.23	136.4294	135.93	136.09	9409759.0
2008-06-16 12:30:00	SPY	ETF	136.08	136.46	136.03	136.27	6124989.0
2008-06-16 13:00:00	SPY	ETF	136.28	136.76	135.96	136.74	12561821.0
2008-06-16 13:30:00	SPY	ETF	136.75	136.93	136.61	136.73	17058232.0
2008-06-16 14:00:00	SPY	ETF	136.73	136.79	136.44	136.51	8673898.0
2008-06-16 14:30:00	SPY	ETF	136.51	136.87	136.49	136.79	7359513.0
2008-06-16 15:00:00	SPY	ETF	136.8	136.87	136.55	136.605	9895228.0
2008-06-16 15:30:00	SPY	ETF	136.61	136.7144	136.295	136.44	20266922.0
2008-06-16 16:00:00	SPY	ETF	136.37	136.46	136.18	136.27	3176142.0
2008-06-16 16:30:00	SPY	ETF	136.27	136.4294	136.0	136.14	2481941.0
2008-06-16 17:00:00	SPY	ETF	136.13	136.15	136.06	136.09	102766.0
2008-06-16 17:30:00	SPY	ETF	136.15	136.15	136.04	136.1	29539.0
2008-06-16 18:00:00	SPY	ETF	136.1	136.19	136.1	136.18	11109.0
2008-06-16 18:30:00	SPY	ETF	136.19	136.21	136.17	136.18	3118.0
2008-06-16 19:00:00	SPY	ETF	136.18	136.19	136.14	136.17	1800.0
2008-06-16 19:30:00	SPY	ETF	136.13	136.23	136.13	136.23	1358.0
2008-06-16 05:00:00	QQQ	ETF	48.35	48.35	48.35	48.35	100.0
2008-06-16 06:00:00	QQQ	ETF	48.4	48.4	48.4	48.4	200.0
2008-06-16 06:30:00	QQQ	ETF	48.38	48.42	48.38	48.42	2700.0
2008-06-16 07:00:00	QQQ	ETF	48.38	48.38	48.28	48.3	16805.0
2008-06-16 07:30:00	QQQ	ETF	48.28	48.28	48.21	48.21	55851.0
2008-06-16 08:00:00	QQQ	ETF	48.21	48.31	48.21	48.25	528784.0
2008-06-16 08:30:00	QQQ	ETF	48.23	48.23	48.1	48.11	986713.0
2008-06-16 09:00:00	QQQ	ETF	48.11	48.16	48.05	48.13	696300.0
2008-06-16 09:30:00	QQQ	ETF	48.13	48.33	48.07	48.22	16800544.0
2008-06-16 10:00:00	QQQ	ETF	48.22	48.43	48.16	48.31	11065523.0
2008-06-16 10:30:00	QQQ	ETF	48.3	48.73	48.2	48.65	12064852.0
2008-06-16 11:00:00	QQQ	ETF	48.66	48.78	48.53	48.55	11561993.0
2008-06-16 11:30:00	QQQ	ETF	48.55	48.68	48.54	48.6	3503518.0
2008-06-16 12:00:00	QQQ	ETF	48.61	48.62	48.45	48.55	3798877.0
2008-06-16 12:30:00	QQQ	ETF	48.55	48.66	48.53	48.5889	4225202.0
2008-06-16 13:00:00	QQQ	ETF	48.59	48.83	48.49	48.83	7903804.0
2008-06-16 13:30:00	QQQ	ETF	48.83	49.02	48.81	48.93	15239519.0
2008-06-16 14:00:00	QQQ	ETF	48.94	48.94	48.74	48.78	7520355.0
2008-06-16 14:30:00	QQQ	ETF	48.7879	48.96	48.76	48.9201	4106469.0

> showing 50 of 5,646 rows — these rows as CSV

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