PREVIEW / etf_30min / 2009-04-09

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-04-09.parquet
  size:    217 KB
  rows:    7,124

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
2009-04-09 04:00:00	SPY	ETF	83.22	83.22	83.14	83.14	1500.0
2009-04-09 05:00:00	SPY	ETF	83.33	83.35	83.3	83.31	25700.0
2009-04-09 05:30:00	SPY	ETF	83.33	83.5	83.3	83.5	22050.0
2009-04-09 06:00:00	SPY	ETF	83.45	83.45	83.3	83.36	15800.0
2009-04-09 06:30:00	SPY	ETF	83.35	83.35	83.23	83.27	10300.0
2009-04-09 07:00:00	SPY	ETF	83.26	83.31	83.08	83.2	237459.0
2009-04-09 07:30:00	SPY	ETF	83.16	83.23	83.0	83.1	316379.0
2009-04-09 08:00:00	SPY	ETF	83.09	84.4	83.09	84.3	6788589.0
2009-04-09 08:30:00	SPY	ETF	84.29	84.83	84.2	84.61	5036031.0
2009-04-09 09:00:00	SPY	ETF	84.61	84.75	82.49	84.67	2787511.0
2009-04-09 09:30:00	SPY	ETF	84.67	85.09	84.33	85.05	40639579.0
2009-04-09 10:00:00	SPY	ETF	85.05	85.19	84.88	85.0	28082971.0
2009-04-09 10:30:00	SPY	ETF	85.01	85.1	84.69	84.8	16207123.0
2009-04-09 11:00:00	SPY	ETF	84.8	84.94	84.59	84.59	12597080.0
2009-04-09 11:30:00	SPY	ETF	84.6	84.74	84.43	84.72	13018930.0
2009-04-09 12:00:00	SPY	ETF	84.72	84.84	84.54	84.79	13260378.0
2009-04-09 12:30:00	SPY	ETF	84.79	84.9	84.75	84.77	9721189.0
2009-04-09 13:00:00	SPY	ETF	84.78	85.08	84.66	84.87	10318002.0
2009-04-09 13:30:00	SPY	ETF	84.87	85.1	84.79	85.0601	7441397.0
2009-04-09 14:00:00	SPY	ETF	85.07	85.14	84.73	84.94	12887231.0
2009-04-09 14:30:00	SPY	ETF	84.95	85.49	84.94	85.31	19551039.0
2009-04-09 15:00:00	SPY	ETF	85.31	85.46	85.15	85.35	12642622.0
2009-04-09 15:30:00	SPY	ETF	85.34	85.82	84.95	85.82	43520773.0
2009-04-09 16:00:00	SPY	ETF	85.81	85.86	85.55	85.66	10624890.0
2009-04-09 16:30:00	SPY	ETF	85.66	85.94	85.55	85.86	3030674.0
2009-04-09 17:00:00	SPY	ETF	85.87	85.88	85.5	85.57	356097.0
2009-04-09 17:30:00	SPY	ETF	85.56	85.65	85.55	85.63	39887.0
2009-04-09 18:00:00	SPY	ETF	85.63	85.65	85.59	85.59	60343.0
2009-04-09 18:30:00	SPY	ETF	85.59	85.61	85.57	85.59	19626.0
2009-04-09 19:00:00	SPY	ETF	85.58	85.62	85.56	85.57	15068.0
2009-04-09 19:30:00	SPY	ETF	85.57	85.68	85.57	85.64	20162.0
2009-04-09 04:00:00	QQQ	ETF	32.19	32.19	32.1	32.1	4000.0
2009-04-09 06:00:00	QQQ	ETF	32.25	32.25	32.2	32.2	7000.0
2009-04-09 06:30:00	QQQ	ETF	32.2	32.2	32.2	32.2	5200.0
2009-04-09 07:00:00	QQQ	ETF	32.19	32.23	31.98	32.11	325525.0
2009-04-09 07:30:00	QQQ	ETF	32.11	32.17	32.05	32.12	192795.0
2009-04-09 08:00:00	QQQ	ETF	32.11	32.45	32.11	32.43	1590897.0
2009-04-09 08:30:00	QQQ	ETF	32.42	32.57	32.38	32.52	2051999.0
2009-04-09 09:00:00	QQQ	ETF	32.52	32.58	32.49	32.54	1215238.0
2009-04-09 09:30:00	QQQ	ETF	32.54	32.95	32.43	32.91	22443515.0
2009-04-09 10:00:00	QQQ	ETF	32.91	32.99	32.87	32.91	11715041.0
2009-04-09 10:30:00	QQQ	ETF	32.92	32.94	32.77	32.78	7371833.0
2009-04-09 11:00:00	QQQ	ETF	32.7812	32.88	32.71	32.73	5698762.0
2009-04-09 11:30:00	QQQ	ETF	32.73	32.88	32.7	32.85	5961683.0
2009-04-09 12:00:00	QQQ	ETF	32.86	32.89	32.77	32.85	5829536.0
2009-04-09 12:30:00	QQQ	ETF	32.849	32.89	32.83	32.85	3342257.0
2009-04-09 13:00:00	QQQ	ETF	32.85	32.95	32.84	32.89	4611059.0
2009-04-09 13:30:00	QQQ	ETF	32.89	32.96	32.85	32.94	4279850.0
2009-04-09 14:00:00	QQQ	ETF	32.9401	32.98	32.84	32.92	5459487.0
2009-04-09 14:30:00	QQQ	ETF	32.92	33.01	32.92	32.95	12272566.0

> showing 50 of 7,124 rows — these rows as CSV

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