PREVIEW / etf_30min / 2009-03-26

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-03-26.parquet
  size:    213 KB
  rows:    7,090

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-03-26 04:00:00	SPY	ETF	82.15	82.18	82.15	82.18	1000.0
2009-03-26 04:30:00	SPY	ETF	81.9	81.9	81.76	81.76	810.0
2009-03-26 05:00:00	SPY	ETF	81.82	82.05	81.82	81.93	3200.0
2009-03-26 05:30:00	SPY	ETF	81.82	81.89	81.74	81.81	52300.0
2009-03-26 06:00:00	SPY	ETF	81.8	82.12	81.8	82.1	45800.0
2009-03-26 06:30:00	SPY	ETF	82.12	82.18	81.97	82.04	12543.0
2009-03-26 07:00:00	SPY	ETF	82.01	82.18	81.88	81.88	991004.0
2009-03-26 07:30:00	SPY	ETF	81.89	82.28	81.85	82.22	552621.0
2009-03-26 08:00:00	SPY	ETF	82.23	82.46	82.04	82.35	4036912.0
2009-03-26 08:30:00	SPY	ETF	82.34	82.54	81.87	82.22	3017379.0
2009-03-26 09:00:00	SPY	ETF	82.21	82.29	81.97	82.25	3145743.0
2009-03-26 09:30:00	SPY	ETF	82.25	82.7	81.74	81.84	47566305.0
2009-03-26 10:00:00	SPY	ETF	81.83	82.21	81.48	81.6	25304932.0
2009-03-26 10:30:00	SPY	ETF	81.6	82.28	81.5	82.01	27394048.0
2009-03-26 11:00:00	SPY	ETF	82.01	82.39	81.92	82.01	19641344.0
2009-03-26 11:30:00	SPY	ETF	82.01	82.5	81.92	82.195	21995444.0
2009-03-26 12:00:00	SPY	ETF	82.2	82.65	82.1	82.6	27451505.0
2009-03-26 12:30:00	SPY	ETF	82.6	82.64	82.02	82.12	18760929.0
2009-03-26 13:00:00	SPY	ETF	82.12	83.25	82.1	82.99	36761869.0
2009-03-26 13:30:00	SPY	ETF	82.99	83.13	82.66	82.77	20228634.0
2009-03-26 14:00:00	SPY	ETF	82.77	83.21	82.6	82.625	21458868.0
2009-03-26 14:30:00	SPY	ETF	82.62	82.81	82.06	82.09	28739475.0
2009-03-26 15:00:00	SPY	ETF	82.0801	82.96	82.04	82.87	35186329.0
2009-03-26 15:30:00	SPY	ETF	82.87	83.3	82.71	83.17	56135355.0
2009-03-26 16:00:00	SPY	ETF	83.07	83.41	81.3721	83.05	10052237.0
2009-03-26 16:30:00	SPY	ETF	83.06	83.08	82.99	83.04	3429257.0
2009-03-26 17:00:00	SPY	ETF	83.03	83.27	83.02	83.25	8123930.0
2009-03-26 17:30:00	SPY	ETF	83.23	83.24	83.12	83.16	27524.0
2009-03-26 18:00:00	SPY	ETF	83.15	83.36	83.15	83.3	344163.0
2009-03-26 18:30:00	SPY	ETF	83.26	83.27	83.06	83.06	30254.0
2009-03-26 19:00:00	SPY	ETF	83.08	83.11	83.05	83.09	20397.0
2009-03-26 19:30:00	SPY	ETF	83.09	83.1	82.99	82.99	78606.0
2009-03-26 04:00:00	QQQ	ETF	30.79	30.79	30.71	30.71	1250.0
2009-03-26 04:30:00	QQQ	ETF	30.68	30.68	30.67	30.67	200.0
2009-03-26 05:00:00	QQQ	ETF	30.7	30.7	30.7	30.7	100.0
2009-03-26 06:00:00	QQQ	ETF	30.71	30.73	30.71	30.73	10200.0
2009-03-26 06:30:00	QQQ	ETF	30.74	30.74	30.72	30.72	1670.0
2009-03-26 07:00:00	QQQ	ETF	30.67	30.79	30.67	30.69	474897.0
2009-03-26 07:30:00	QQQ	ETF	30.7	30.81	30.68	30.81	519785.0
2009-03-26 08:00:00	QQQ	ETF	30.81	30.95	30.71	30.93	2965720.0
2009-03-26 08:30:00	QQQ	ETF	30.94	31.0	30.73	30.86	895392.0
2009-03-26 09:00:00	QQQ	ETF	30.86	30.88	30.81	30.88	1223639.0
2009-03-26 09:30:00	QQQ	ETF	30.88	31.09	30.76	30.86	18991874.0
2009-03-26 10:00:00	QQQ	ETF	30.86	31.03	30.75	30.77	9148291.0
2009-03-26 10:30:00	QQQ	ETF	30.77	31.03	30.75	30.95	12334089.0
2009-03-26 11:00:00	QQQ	ETF	30.95	31.17	30.92	31.02	10448114.0
2009-03-26 11:30:00	QQQ	ETF	31.03	31.17	31.01	31.1	6835926.0
2009-03-26 12:00:00	QQQ	ETF	31.09	31.28	31.05	31.25	9411766.0
2009-03-26 12:30:00	QQQ	ETF	31.25	31.27	31.06	31.08	8129717.0
2009-03-26 13:00:00	QQQ	ETF	31.07	31.45	31.065	31.38	15185623.0

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

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