PREVIEW / etf_30min / 2007-03-14

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-03-14.parquet
  size:    109 KB
  rows:    3,691

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-03-14 04:00:00	SPY	ETF	138.27	138.27	138.27	138.27	100.0
2007-03-14 05:00:00	SPY	ETF	138.21	138.21	138.21	138.21	2000.0
2007-03-14 05:30:00	SPY	ETF	138.34	138.34	138.2	138.2	4600.0
2007-03-14 06:00:00	SPY	ETF	138.1	138.21	138.1	138.21	2000.0
2007-03-14 06:30:00	SPY	ETF	138.18	138.18	137.95	138.04	130700.0
2007-03-14 07:00:00	SPY	ETF	138.09	138.33	138.09	138.33	448100.0
2007-03-14 07:30:00	SPY	ETF	138.35	138.37	137.76	138.02	460300.0
2007-03-14 08:00:00	SPY	ETF	138.02	138.36	137.78	137.97	1816900.0
2007-03-14 08:30:00	SPY	ETF	137.98	138.33	137.96	138.15	2098600.0
2007-03-14 09:00:00	SPY	ETF	138.14	138.52	138.11	138.44	2527400.0
2007-03-14 09:30:00	SPY	ETF	138.43	138.87	138.19	138.38	22204700.0
2007-03-14 10:00:00	SPY	ETF	138.38	138.51	137.01	138.25	16918100.0
2007-03-14 10:30:00	SPY	ETF	138.25	138.88	138.21	138.46	13971200.0
2007-03-14 11:00:00	SPY	ETF	138.46	138.58	138.22	138.26	5983200.0
2007-03-14 11:30:00	SPY	ETF	138.26	138.32	137.94	138.1	7886100.0
2007-03-14 12:00:00	SPY	ETF	138.1	138.11	136.75	137.25	31838800.0
2007-03-14 12:30:00	SPY	ETF	137.25	137.46	136.75	136.97	19522800.0
2007-03-14 13:00:00	SPY	ETF	136.97	138.87	136.91	137.9	24152400.0
2007-03-14 13:30:00	SPY	ETF	137.91	138.51	137.74	138.0	15723700.0
2007-03-14 14:00:00	SPY	ETF	138.0	138.63	137.86	138.54	10493800.0
2007-03-14 14:30:00	SPY	ETF	138.54	139.17	138.5	138.71	18748000.0
2007-03-14 15:00:00	SPY	ETF	138.7	139.24	138.67	139.04	14379600.0
2007-03-14 15:30:00	SPY	ETF	139.05	139.15	138.58	139.14	13661300.0
2007-03-14 16:00:00	SPY	ETF	139.14	139.38	139.0185	139.32	1372200.0
2007-03-14 16:30:00	SPY	ETF	139.32	139.37	139.05	139.37	1398800.0
2007-03-14 17:00:00	SPY	ETF	139.38	139.58	139.36	139.56	149600.0
2007-03-14 17:30:00	SPY	ETF	139.5	139.59	139.49	139.57	22300.0
2007-03-14 18:00:00	SPY	ETF	139.55	139.58	139.5	139.56	12500.0
2007-03-14 18:30:00	SPY	ETF	139.53	139.56	139.51	139.55	2445800.0
2007-03-14 19:00:00	SPY	ETF	139.52	139.55	139.51	139.52	18900.0
2007-03-14 19:30:00	SPY	ETF	139.51	139.51	139.45	139.5	7400.0
2007-03-14 07:00:00	QQQ	ETF	42.28	42.4	42.28	42.38	112104.0
2007-03-14 07:30:00	QQQ	ETF	42.4	42.41	42.2	42.32	324227.0
2007-03-14 08:00:00	QQQ	ETF	42.3	42.33	42.25	42.29	537178.0
2007-03-14 08:30:00	QQQ	ETF	42.3	42.37	42.28	42.33	873555.0
2007-03-14 09:00:00	QQQ	ETF	42.32	42.45	42.31	42.43	1014607.0
2007-03-14 09:30:00	QQQ	ETF	42.43	42.56	42.34	42.45	21989800.0
2007-03-14 10:00:00	QQQ	ETF	42.46	42.58	42.26	42.49	16290800.0
2007-03-14 10:30:00	QQQ	ETF	42.5	42.65	42.47	42.51	10110500.0
2007-03-14 11:00:00	QQQ	ETF	42.52	42.55	42.45	42.48	5984900.0
2007-03-14 11:30:00	QQQ	ETF	42.48	42.49	42.34	42.4	7824100.0
2007-03-14 12:00:00	QQQ	ETF	42.4	42.4	42.1	42.24	16362900.0
2007-03-14 12:30:00	QQQ	ETF	42.25	42.35	42.11	42.21	11840600.0
2007-03-14 13:00:00	QQQ	ETF	42.21	42.61	42.19	42.51	25764300.0
2007-03-14 13:30:00	QQQ	ETF	42.52	42.66	42.39	42.44	16724100.0
2007-03-14 14:00:00	QQQ	ETF	42.44	42.65	42.36	42.63	10273400.0
2007-03-14 14:30:00	QQQ	ETF	42.64	42.87	42.61	42.72	16079400.0
2007-03-14 15:00:00	QQQ	ETF	42.72	42.89	42.71	42.82	10646500.0
2007-03-14 15:30:00	QQQ	ETF	42.82	42.89	42.7	42.89	13069000.0
2007-03-14 16:00:00	QQQ	ETF	42.9	43.02	42.89	43.01	3892933.0

> showing 50 of 3,691 rows — these rows as CSV

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