PREVIEW / etf_30min / 2007-03-20

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-03-20.parquet
  size:    104 KB
  rows:    3,603

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-20 06:30:00	SPY	ETF	140.0	140.0	140.0	140.0	5000.0
2007-03-20 07:00:00	SPY	ETF	140.01	140.04	139.95	139.95	79100.0
2007-03-20 07:30:00	SPY	ETF	139.96	140.01	139.93	139.99	84700.0
2007-03-20 08:00:00	SPY	ETF	139.97	140.17	139.97	140.09	507800.0
2007-03-20 08:30:00	SPY	ETF	140.12	140.39	140.11	140.13	2470000.0
2007-03-20 09:00:00	SPY	ETF	140.11	140.23	140.0	140.08	621000.0
2007-03-20 09:30:00	SPY	ETF	140.08	140.32	139.96	140.05	7364242.0
2007-03-20 10:00:00	SPY	ETF	140.05	140.28	139.97	140.21	4630000.0
2007-03-20 10:30:00	SPY	ETF	140.21	140.42	140.12	140.3599	6719400.0
2007-03-20 11:00:00	SPY	ETF	140.36	140.55	140.34	140.48	5267758.0
2007-03-20 11:30:00	SPY	ETF	140.48	140.59	140.35	140.58	2872400.0
2007-03-20 12:00:00	SPY	ETF	140.59	140.95	140.56	140.92	8174800.0
2007-03-20 12:30:00	SPY	ETF	140.92	141.04	140.76	140.8	5946625.0
2007-03-20 13:00:00	SPY	ETF	140.8	141.01	140.69	140.74	7194257.0
2007-03-20 13:30:00	SPY	ETF	140.74	140.77	140.5	140.59	5188800.0
2007-03-20 14:00:00	SPY	ETF	140.59	140.74	140.56	140.62	2352500.0
2007-03-20 14:30:00	SPY	ETF	140.63	140.73	140.49	140.63	4366138.0
2007-03-20 15:00:00	SPY	ETF	140.63	140.91	140.5	140.82	6001414.0
2007-03-20 15:30:00	SPY	ETF	140.81	141.04	140.81	140.93	7083467.0
2007-03-20 16:00:00	SPY	ETF	140.94	141.07	140.9	141.0	1425300.0
2007-03-20 16:30:00	SPY	ETF	140.98	140.98	140.93	140.95	75200.0
2007-03-20 17:00:00	SPY	ETF	140.95	140.97	140.87	140.87	427300.0
2007-03-20 17:30:00	SPY	ETF	140.86	140.95	140.8	140.95	519100.0
2007-03-20 18:00:00	SPY	ETF	140.88	140.9	140.88	140.88	8100.0
2007-03-20 18:30:00	SPY	ETF	140.88	140.91	140.86	140.89	702100.0
2007-03-20 19:30:00	SPY	ETF	140.87	140.9	140.85	140.9	2800.0
2007-03-20 07:30:00	QQQ	ETF	43.25	43.25	43.25	43.25	50000.0
2007-03-20 08:00:00	QQQ	ETF	43.24	43.27	43.21	43.26	157904.0
2007-03-20 08:30:00	QQQ	ETF	43.27	43.42	43.27	43.31	1801049.0
2007-03-20 09:00:00	QQQ	ETF	43.31	43.34	43.26	43.27	500453.0
2007-03-20 09:30:00	QQQ	ETF	43.27	43.34	43.21	43.23	7408600.0
2007-03-20 10:00:00	QQQ	ETF	43.24	43.36	43.23	43.31	4002200.0
2007-03-20 10:30:00	QQQ	ETF	43.3	43.41	43.28	43.36	4108600.0
2007-03-20 11:00:00	QQQ	ETF	43.36	43.46	43.36	43.41	5524300.0
2007-03-20 11:30:00	QQQ	ETF	43.4	43.43	43.34	43.43	2489500.0
2007-03-20 12:00:00	QQQ	ETF	43.43	43.53	43.41	43.51	4267100.0
2007-03-20 12:30:00	QQQ	ETF	43.51	43.53	43.48	43.52	3612400.0
2007-03-20 13:00:00	QQQ	ETF	43.51	43.59	43.45	43.46	5547800.0
2007-03-20 13:30:00	QQQ	ETF	43.46	43.48	43.32	43.37	7096100.0
2007-03-20 14:00:00	QQQ	ETF	43.36	43.4	43.34	43.36	2456600.0
2007-03-20 14:30:00	QQQ	ETF	43.35	43.41	43.32	43.38	5827600.0
2007-03-20 15:00:00	QQQ	ETF	43.39	43.48	43.38	43.46	6068000.0
2007-03-20 15:30:00	QQQ	ETF	43.46	43.53	43.42	43.45	9164600.0
2007-03-20 16:00:00	QQQ	ETF	43.45	43.63	43.44	43.59	6052436.0
2007-03-20 16:30:00	QQQ	ETF	43.59	43.59	43.44	43.56	1447328.0
2007-03-20 17:00:00	QQQ	ETF	43.56	43.57	43.52	43.53	248350.0
2007-03-20 17:30:00	QQQ	ETF	43.53	43.57	43.53	43.56	31478.0
2007-03-20 18:00:00	QQQ	ETF	43.55	43.57	43.54	43.56	1239153.0
2007-03-20 18:30:00	QQQ	ETF	43.56	43.57	43.56	43.57	29746.0
2007-03-20 19:00:00	QQQ	ETF	43.55	43.56	43.54	43.56	4400.0

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

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