PREVIEW / etf_30min / 2009-03-30

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-03-30.parquet
  size:    210 KB
  rows:    6,995

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-30 04:00:00	SPY	ETF	79.6	80.35	79.6	79.93	8984.0
2009-03-30 04:30:00	SPY	ETF	80.05	80.05	79.8	79.8	3200.0
2009-03-30 05:00:00	SPY	ETF	79.9	80.04	79.84	80.0	45800.0
2009-03-30 05:30:00	SPY	ETF	79.95	80.0	79.88	80.0	44480.0
2009-03-30 06:00:00	SPY	ETF	80.13	80.13	79.96	80.0	14491.0
2009-03-30 06:30:00	SPY	ETF	80.0	80.22	80.0	80.19	145020.0
2009-03-30 07:00:00	SPY	ETF	80.19	80.34	80.09	80.17	666177.0
2009-03-30 07:30:00	SPY	ETF	80.2	80.25	80.04	80.06	438509.0
2009-03-30 08:00:00	SPY	ETF	80.06	81.3817	79.72	80.17	2459591.0
2009-03-30 08:30:00	SPY	ETF	79.35	80.2	79.35	80.0	862863.0
2009-03-30 09:00:00	SPY	ETF	80.0	80.04	79.72	79.79	2085710.0
2009-03-30 09:30:00	SPY	ETF	79.8	79.87	79.03	79.3	46259576.0
2009-03-30 10:00:00	SPY	ETF	79.3	79.44	79.04	79.21	24100652.0
2009-03-30 10:30:00	SPY	ETF	79.2	79.2	78.6	78.8	25397937.0
2009-03-30 11:00:00	SPY	ETF	78.79	79.08	78.5	78.6	20590937.0
2009-03-30 11:30:00	SPY	ETF	78.6	78.79	78.41	78.76	15811272.0
2009-03-30 12:00:00	SPY	ETF	78.76	79.04	78.61	78.9799	13122111.0
2009-03-30 12:30:00	SPY	ETF	78.97	79.01	78.62	78.65	11258136.0
2009-03-30 13:00:00	SPY	ETF	78.65	78.87	78.53	78.78	11523936.0
2009-03-30 13:30:00	SPY	ETF	78.78	78.88	78.25	78.29	16111538.0
2009-03-30 14:00:00	SPY	ETF	78.29	78.73	78.19	78.42	20016105.0
2009-03-30 14:30:00	SPY	ETF	78.42	78.52	77.96	77.99	21484321.0
2009-03-30 15:00:00	SPY	ETF	77.99	78.71	77.96	78.4298	28571241.0
2009-03-30 15:30:00	SPY	ETF	78.43	78.94	78.27	78.8	50924076.0
2009-03-30 16:00:00	SPY	ETF	78.78	79.5	78.67	78.87	8901295.0
2009-03-30 16:30:00	SPY	ETF	78.87	79.08	78.76	79.02	659408.0
2009-03-30 17:00:00	SPY	ETF	79.05	79.05	78.85	78.9	166879.0
2009-03-30 17:30:00	SPY	ETF	78.87	78.95	78.83	78.95	11775.0
2009-03-30 18:00:00	SPY	ETF	78.91	79.04	78.91	79.02	71430.0
2009-03-30 18:30:00	SPY	ETF	79.02	79.15	79.02	79.15	37619.0
2009-03-30 19:00:00	SPY	ETF	79.13	79.15	79.06	79.13	27380.0
2009-03-30 19:30:00	SPY	ETF	79.14	79.26	79.1	79.26	91463.0
2009-03-30 04:00:00	QQQ	ETF	30.08	30.1	30.08	30.09	901.0
2009-03-30 04:30:00	QQQ	ETF	30.1	30.14	30.1	30.14	790.0
2009-03-30 05:00:00	QQQ	ETF	30.1	30.1	30.09	30.09	300.0
2009-03-30 06:30:00	QQQ	ETF	30.2	30.26	30.2	30.23	2700.0
2009-03-30 07:00:00	QQQ	ETF	30.28	30.36	30.27	30.34	120800.0
2009-03-30 07:30:00	QQQ	ETF	30.33	30.36	30.3	30.3	96789.0
2009-03-30 08:00:00	QQQ	ETF	30.32	30.4	30.25	30.35	447524.0
2009-03-30 08:30:00	QQQ	ETF	30.35	30.4	30.34	30.35	677272.0
2009-03-30 09:00:00	QQQ	ETF	30.35	30.38	30.27	30.29	651467.0
2009-03-30 09:30:00	QQQ	ETF	30.29	30.32	29.86	30.0	29459051.0
2009-03-30 10:00:00	QQQ	ETF	30.0	30.03	29.79	29.84	12739866.0
2009-03-30 10:30:00	QQQ	ETF	29.84	29.84	29.63	29.76	15066471.0
2009-03-30 11:00:00	QQQ	ETF	29.76	29.83	29.63	29.68	11422185.0
2009-03-30 11:30:00	QQQ	ETF	29.68	29.81	29.62	29.81	6231057.0
2009-03-30 12:00:00	QQQ	ETF	29.81	29.91	29.74	29.89	5284252.0
2009-03-30 12:30:00	QQQ	ETF	29.9	29.955	29.8	29.819	5110510.0
2009-03-30 13:00:00	QQQ	ETF	29.819	29.87	29.74	29.83	4376578.0
2009-03-30 13:30:00	QQQ	ETF	29.83	29.88	29.67	29.76	8619267.0

> showing 50 of 6,995 rows — these rows as CSV

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