PREVIEW / etf_30min / 2009-11-18

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-11-18.parquet
  size:    236 KB
  rows:    7,809

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-11-18 04:00:00	SPY	ETF	111.28	111.29	111.15	111.15	2100.0
2009-11-18 04:30:00	SPY	ETF	111.27	111.27	111.27	111.27	700.0
2009-11-18 05:00:00	SPY	ETF	111.27	111.28	111.22	111.25	3500.0
2009-11-18 05:30:00	SPY	ETF	111.28	111.35	111.28	111.35	7500.0
2009-11-18 06:00:00	SPY	ETF	111.38	111.45	111.38	111.45	1000.0
2009-11-18 06:30:00	SPY	ETF	111.45	111.56	111.43	111.56	20700.0
2009-11-18 07:00:00	SPY	ETF	111.44	111.44	111.32	111.36	69430.0
2009-11-18 07:30:00	SPY	ETF	111.34	111.42	111.26	111.42	1408769.0
2009-11-18 08:00:00	SPY	ETF	111.33	111.49	111.24	111.28	2019798.0
2009-11-18 08:30:00	SPY	ETF	111.23	111.33	110.96	111.12	3526234.0
2009-11-18 09:00:00	SPY	ETF	111.12	111.27	111.02	111.26	1517861.0
2009-11-18 09:30:00	SPY	ETF	111.26	111.43	110.71	110.79	28091038.0
2009-11-18 10:00:00	SPY	ETF	110.79	111.28	110.57	110.89	14668165.0
2009-11-18 10:30:00	SPY	ETF	110.9	111.2	110.81	111.08	15550943.0
2009-11-18 11:00:00	SPY	ETF	111.08	111.29	110.92	111.07	9873345.0
2009-11-18 11:30:00	SPY	ETF	111.07	111.13	110.92	111.1	5295197.0
2009-11-18 12:00:00	SPY	ETF	111.11	111.17	110.92	111.019	4607299.0
2009-11-18 12:30:00	SPY	ETF	111.02	111.11	110.8	110.82	6309682.0
2009-11-18 13:00:00	SPY	ETF	110.82	110.85	110.62	110.75	9446413.0
2009-11-18 13:30:00	SPY	ETF	110.75	110.96	110.745	110.88	5654203.0
2009-11-18 14:00:00	SPY	ETF	110.88	111.09	110.86	110.99	5510041.0
2009-11-18 14:30:00	SPY	ETF	110.99	111.06	110.8	110.9	5546053.0
2009-11-18 15:00:00	SPY	ETF	110.91	111.17	110.885	111.1	7948255.0
2009-11-18 15:30:00	SPY	ETF	111.1	111.32	111.0	111.28	16616884.0
2009-11-18 16:00:00	SPY	ETF	111.28	111.39	103.78	111.33	11357897.0
2009-11-18 16:30:00	SPY	ETF	111.34	111.4	111.27	111.37	536431.0
2009-11-18 17:00:00	SPY	ETF	111.36	111.42	111.35	111.42	48012.0
2009-11-18 17:30:00	SPY	ETF	111.42	111.43	111.38	111.42	19333.0
2009-11-18 18:00:00	SPY	ETF	111.41	111.43	111.27	111.39	79582.0
2009-11-18 18:30:00	SPY	ETF	111.38	111.42	111.35	111.35	29745.0
2009-11-18 19:00:00	SPY	ETF	111.38	111.38	111.28	111.32	29205.0
2009-11-18 19:30:00	SPY	ETF	111.31	111.31	111.2	111.2	41809.0
2009-11-18 05:00:00	QQQ	ETF	44.52	44.52	44.52	44.52	4000.0
2009-11-18 06:00:00	QQQ	ETF	44.56	44.56	44.56	44.56	460.0
2009-11-18 07:00:00	QQQ	ETF	44.59	44.59	44.53	44.55	26900.0
2009-11-18 07:30:00	QQQ	ETF	44.55	44.55	44.49	44.5	818172.0
2009-11-18 08:00:00	QQQ	ETF	44.51	44.53	44.45	44.46	1478905.0
2009-11-18 08:30:00	QQQ	ETF	44.47	44.47	44.38	44.42	1432580.0
2009-11-18 09:00:00	QQQ	ETF	44.42	44.48	44.39	44.45	521401.0
2009-11-18 09:30:00	QQQ	ETF	44.46	44.49	44.15	44.18	13579628.0
2009-11-18 10:00:00	QQQ	ETF	44.18	44.4	44.08	44.22	12849374.0
2009-11-18 10:30:00	QQQ	ETF	44.22	44.3195	44.18	44.25	11582595.0
2009-11-18 11:00:00	QQQ	ETF	44.26	44.36	44.21	44.27	8185668.0
2009-11-18 11:30:00	QQQ	ETF	44.27	44.28	44.18	44.27	5212294.0
2009-11-18 12:00:00	QQQ	ETF	44.27	44.285	44.2	44.23	3088354.0
2009-11-18 12:30:00	QQQ	ETF	44.22	44.26	44.16	44.17	3779697.0
2009-11-18 13:00:00	QQQ	ETF	44.16	44.17	44.05	44.1075	5644740.0
2009-11-18 13:30:00	QQQ	ETF	44.11	44.18	44.1	44.155	2398777.0
2009-11-18 14:00:00	QQQ	ETF	44.1405	44.26	44.14	44.22	3746735.0
2009-11-18 14:30:00	QQQ	ETF	44.23	44.245	44.15	44.17	1941470.0

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

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