PREVIEW / etf_30min / 2007-11-14

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-11-14.parquet
  size:    136 KB
  rows:    5,049

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
2007-11-14 04:00:00	SPY	ETF	148.27	148.27	148.27	148.27	3000.0
2007-11-14 04:30:00	SPY	ETF	148.47	148.47	148.34	148.34	3000.0
2007-11-14 05:00:00	SPY	ETF	148.34	148.34	148.34	148.34	1000.0
2007-11-14 05:30:00	SPY	ETF	148.39	148.49	148.39	148.42	63500.0
2007-11-14 06:30:00	SPY	ETF	148.07	148.07	147.91	147.91	80000.0
2007-11-14 07:00:00	SPY	ETF	147.94	147.95	147.58	147.73	699600.0
2007-11-14 07:30:00	SPY	ETF	147.79	148.15	147.73	148.15	568700.0
2007-11-14 08:00:00	SPY	ETF	148.14	148.57	147.62	148.56	5347300.0
2007-11-14 08:30:00	SPY	ETF	148.59	149.41	148.56	149.1	14760600.0
2007-11-14 09:00:00	SPY	ETF	149.09	149.26	149.02	149.22	3390000.0
2007-11-14 09:30:00	SPY	ETF	149.22	149.4	148.51	148.66	28995639.0
2007-11-14 10:00:00	SPY	ETF	148.66	148.95	148.3	148.66	22073787.0
2007-11-14 10:30:00	SPY	ETF	148.66	148.88	148.32	148.54	12232867.0
2007-11-14 11:00:00	SPY	ETF	148.54	148.75	148.15	148.43	13246350.0
2007-11-14 11:30:00	SPY	ETF	148.43	148.91	148.31	148.78	7816871.0
2007-11-14 12:00:00	SPY	ETF	148.78	149.26	148.66	149.11	9803648.0
2007-11-14 12:30:00	SPY	ETF	149.11	149.111	148.6	148.63	5769980.0
2007-11-14 13:00:00	SPY	ETF	148.63	149.12	148.63	149.0	5428391.0
2007-11-14 13:30:00	SPY	ETF	149.01	149.04	148.39	148.4	6977955.0
2007-11-14 14:00:00	SPY	ETF	148.39	149.07	148.3	148.78	8878980.0
2007-11-14 14:30:00	SPY	ETF	148.79	148.92	148.42	148.46	8462223.0
2007-11-14 15:00:00	SPY	ETF	148.44	148.86	148.29	148.7	9117990.0
2007-11-14 15:30:00	SPY	ETF	148.7	148.71	146.78	147.1	46926581.0
2007-11-14 16:00:00	SPY	ETF	147.06	149.2	146.9	147.5	5828600.0
2007-11-14 16:30:00	SPY	ETF	147.55	148.2974	147.5	147.75	6618200.0
2007-11-14 17:00:00	SPY	ETF	147.75	147.79	147.6	147.66	2781100.0
2007-11-14 17:30:00	SPY	ETF	147.64	147.64	147.25	147.4	164000.0
2007-11-14 18:00:00	SPY	ETF	147.53	147.7	147.47	147.58	421300.0
2007-11-14 18:30:00	SPY	ETF	147.59	147.59	147.5	147.58	17900.0
2007-11-14 19:00:00	SPY	ETF	147.57	147.6	147.46	147.6	7600.0
2007-11-14 19:30:00	SPY	ETF	147.61	147.63	147.49	147.58	15300.0
2007-11-14 04:30:00	QQQ	ETF	50.66	50.66	50.66	50.66	800.0
2007-11-14 05:00:00	QQQ	ETF	50.67	50.7	50.67	50.7	1000.0
2007-11-14 05:30:00	QQQ	ETF	50.72	50.76	50.72	50.76	51900.0
2007-11-14 06:00:00	QQQ	ETF	50.77	50.79	50.71	50.71	32200.0
2007-11-14 06:30:00	QQQ	ETF	50.64	50.68	50.64	50.67	4610.0
2007-11-14 07:00:00	QQQ	ETF	50.62	50.62	50.52	50.55	183466.0
2007-11-14 07:30:00	QQQ	ETF	50.54	50.64	50.5	50.63	150242.0
2007-11-14 08:00:00	QQQ	ETF	50.64	50.96	50.59	50.92	1411301.0
2007-11-14 08:30:00	QQQ	ETF	50.94	51.45	50.9	51.4	11165244.0
2007-11-14 09:00:00	QQQ	ETF	51.4	51.49	51.35	51.39	3665453.0
2007-11-14 09:30:00	QQQ	ETF	51.4	51.44	50.81	50.88	39229728.0
2007-11-14 10:00:00	QQQ	ETF	50.87	51.09	50.8	51.01	18628906.0
2007-11-14 10:30:00	QQQ	ETF	51.02	51.03	50.85	50.88	12152543.0
2007-11-14 11:00:00	QQQ	ETF	50.89	50.93	50.58	50.74	17223572.0
2007-11-14 11:30:00	QQQ	ETF	50.75	50.98	50.63	50.8514	11751420.0
2007-11-14 12:00:00	QQQ	ETF	50.86	51.15	50.83	51.0891	15225516.0
2007-11-14 12:30:00	QQQ	ETF	51.09	51.1	50.86	50.88	7582585.0
2007-11-14 13:00:00	QQQ	ETF	50.88	51.11	50.85	51.07	7691482.0
2007-11-14 13:30:00	QQQ	ETF	51.07	51.09	50.71	50.72	13075860.0

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

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