PREVIEW / etf_30min / 2008-06-05

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-06-05.parquet
  size:    167 KB
  rows:    5,809

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-05 04:00:00	SPY	ETF	138.53	138.7	138.53	138.57	14700.0
2008-06-05 04:30:00	SPY	ETF	138.53	138.59	138.53	138.59	7100.0
2008-06-05 05:00:00	SPY	ETF	138.54	138.54	138.46	138.46	500.0
2008-06-05 06:00:00	SPY	ETF	138.52	138.54	138.3	138.3	6100.0
2008-06-05 06:30:00	SPY	ETF	138.27	138.3	138.27	138.28	3000.0
2008-06-05 07:00:00	SPY	ETF	138.23	138.71	138.21	138.63	1378590.0
2008-06-05 07:30:00	SPY	ETF	138.63	138.68	138.53	138.66	339137.0
2008-06-05 08:00:00	SPY	ETF	138.68	138.96	138.61	138.96	4284629.0
2008-06-05 08:30:00	SPY	ETF	138.96	139.19	138.52	138.56	3960792.0
2008-06-05 09:00:00	SPY	ETF	138.57	138.67	138.47	138.56	2142467.0
2008-06-05 09:30:00	SPY	ETF	138.58	139.14	138.32	139.05	21655990.0
2008-06-05 10:00:00	SPY	ETF	139.06	139.66	138.74	139.525	32196462.0
2008-06-05 10:30:00	SPY	ETF	139.52	139.79	139.48	139.55	11545458.0
2008-06-05 11:00:00	SPY	ETF	139.54	139.67	139.32	139.51	12270226.0
2008-06-05 11:30:00	SPY	ETF	139.508	139.75	139.38	139.61	7339355.0
2008-06-05 12:00:00	SPY	ETF	139.61	140.1	139.55	140.02	16145653.0
2008-06-05 12:30:00	SPY	ETF	140.02	140.16	139.95	140.08	9237296.0
2008-06-05 13:00:00	SPY	ETF	140.08	140.2	139.91	140.04	10168031.0
2008-06-05 13:30:00	SPY	ETF	140.04	140.23	139.93	140.02	8702719.0
2008-06-05 14:00:00	SPY	ETF	140.02	140.05	139.0	139.505	33812760.0
2008-06-05 14:30:00	SPY	ETF	139.51	140.1474	139.43	140.11	16575886.0
2008-06-05 15:00:00	SPY	ETF	140.12	140.57	140.01	140.409	16700622.0
2008-06-05 15:30:00	SPY	ETF	140.4	140.83	140.35	140.64	18078459.0
2008-06-05 16:00:00	SPY	ETF	140.69	140.89	138.0814	140.87	5751277.0
2008-06-05 16:30:00	SPY	ETF	140.84	140.91	140.79	140.82	166354.0
2008-06-05 17:00:00	SPY	ETF	140.85	140.88	140.77	140.88	299419.0
2008-06-05 17:30:00	SPY	ETF	140.83	140.9	139.05	140.8	120000.0
2008-06-05 18:00:00	SPY	ETF	140.81	140.85	140.81	140.82	5090.0
2008-06-05 18:30:00	SPY	ETF	140.82	140.82	140.79	140.79	3700.0
2008-06-05 19:00:00	SPY	ETF	140.77	140.85	140.77	140.85	3184.0
2008-06-05 19:30:00	SPY	ETF	140.85	140.87	140.82	140.82	19737.0
2008-06-05 04:00:00	QQQ	ETF	49.82	49.82	49.82	49.82	300.0
2008-06-05 06:30:00	QQQ	ETF	49.81	49.81	49.76	49.76	7400.0
2008-06-05 07:00:00	QQQ	ETF	49.76	49.95	49.74	49.93	530339.0
2008-06-05 07:30:00	QQQ	ETF	49.92	49.96	49.88	49.96	326473.0
2008-06-05 08:00:00	QQQ	ETF	49.95	50.04	49.84	50.01	1574359.0
2008-06-05 08:30:00	QQQ	ETF	50.0	50.12	49.89	49.89	890650.0
2008-06-05 09:00:00	QQQ	ETF	49.9	49.92	49.85	49.86	1405620.0
2008-06-05 09:30:00	QQQ	ETF	49.87	50.17	49.7	50.1101	15798662.0
2008-06-05 10:00:00	QQQ	ETF	50.12	50.38	50.05	50.32	20067588.0
2008-06-05 10:30:00	QQQ	ETF	50.32	50.41	50.28	50.3276	7003772.0
2008-06-05 11:00:00	QQQ	ETF	50.325	50.37	50.26	50.325	6490278.0
2008-06-05 11:30:00	QQQ	ETF	50.31	50.41	50.25	50.35	4053288.0
2008-06-05 12:00:00	QQQ	ETF	50.35	50.45	50.32	50.43	6529425.0
2008-06-05 12:30:00	QQQ	ETF	50.44	50.47	50.3208	50.41	5202596.0
2008-06-05 13:00:00	QQQ	ETF	50.41	50.47	50.32	50.39	4290015.0
2008-06-05 13:30:00	QQQ	ETF	50.39	50.47	50.35	50.39	3788790.0
2008-06-05 14:00:00	QQQ	ETF	50.39	50.4	50.13	50.19	10194975.0
2008-06-05 14:30:00	QQQ	ETF	50.1822	50.39	50.15	50.39	6746317.0
2008-06-05 15:00:00	QQQ	ETF	50.389	50.61	50.35	50.49	11868000.0

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

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