PREVIEW / etf_30min / 2009-09-23

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-09-23.parquet
  size:    234 KB
  rows:    7,710

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-09-23 04:00:00	SPY	ETF	107.45	107.45	107.33	107.33	1300.0
2009-09-23 04:30:00	SPY	ETF	107.34	107.45	107.34	107.45	500.0
2009-09-23 05:00:00	SPY	ETF	107.42	107.48	107.42	107.44	500.0
2009-09-23 05:30:00	SPY	ETF	107.44	107.44	107.13	107.14	60700.0
2009-09-23 06:00:00	SPY	ETF	107.16	107.26	107.16	107.21	34400.0
2009-09-23 06:30:00	SPY	ETF	107.26	107.29	107.26	107.26	30000.0
2009-09-23 07:00:00	SPY	ETF	107.27	107.4	107.27	107.4	131696.0
2009-09-23 07:30:00	SPY	ETF	107.42	107.5	107.37	107.41	311653.0
2009-09-23 08:00:00	SPY	ETF	107.39	107.43	107.05	107.37	547759.0
2009-09-23 08:30:00	SPY	ETF	107.37	107.44	107.33	107.39	259028.0
2009-09-23 09:00:00	SPY	ETF	107.38	107.43	107.32	107.33	664193.0
2009-09-23 09:30:00	SPY	ETF	107.32	107.33	106.98	107.0199	16010481.0
2009-09-23 10:00:00	SPY	ETF	107.02	107.25	106.94	107.18	9467704.0
2009-09-23 10:30:00	SPY	ETF	107.17	107.18	106.68	106.92	13215454.0
2009-09-23 11:00:00	SPY	ETF	106.92	106.97	106.74	106.94	5188985.0
2009-09-23 11:30:00	SPY	ETF	106.95	107.12	106.88	107.1	5502670.0
2009-09-23 12:00:00	SPY	ETF	107.1	107.28	107.09	107.219	6572903.0
2009-09-23 12:30:00	SPY	ETF	107.21	107.32	107.15	107.3	3584761.0
2009-09-23 13:00:00	SPY	ETF	107.3	107.41	107.19	107.2299	6315406.0
2009-09-23 13:30:00	SPY	ETF	107.23	107.38	107.15	107.3601	7503931.0
2009-09-23 14:00:00	SPY	ETF	107.36	107.82	107.18	107.75	22223795.0
2009-09-23 14:30:00	SPY	ETF	107.75	108.03	107.3	107.39	30379005.0
2009-09-23 15:00:00	SPY	ETF	107.39	107.68	106.89	106.99	36924761.0
2009-09-23 15:30:00	SPY	ETF	107.0	107.01	105.99	106.12	50364580.0
2009-09-23 16:00:00	SPY	ETF	106.11	107.77	106.045	106.31	8914678.0
2009-09-23 16:30:00	SPY	ETF	106.31	107.1461	106.23	106.29	412207.0
2009-09-23 17:00:00	SPY	ETF	106.29	106.29	106.16	106.19	156319.0
2009-09-23 17:30:00	SPY	ETF	106.18	106.25	106.18	106.23	42085.0
2009-09-23 18:00:00	SPY	ETF	106.21	106.24	106.14	106.18	67500.0
2009-09-23 18:30:00	SPY	ETF	106.19	106.19	106.16	106.17	25436.0
2009-09-23 19:00:00	SPY	ETF	106.17	106.19	106.1	106.13	58665.0
2009-09-23 19:30:00	SPY	ETF	106.11	106.21	106.11	106.21	16452.0
2009-09-23 04:00:00	QQQ	ETF	42.81	42.81	42.81	42.81	100.0
2009-09-23 05:00:00	QQQ	ETF	42.82	42.82	42.82	42.82	400.0
2009-09-23 05:30:00	QQQ	ETF	42.82	42.82	42.7	42.7	3600.0
2009-09-23 07:00:00	QQQ	ETF	42.78	42.84	42.78	42.84	62118.0
2009-09-23 07:30:00	QQQ	ETF	42.81	42.84	42.81	42.82	20700.0
2009-09-23 08:00:00	QQQ	ETF	42.8	42.84	42.79	42.81	425276.0
2009-09-23 08:30:00	QQQ	ETF	42.82	42.87	42.81	42.84	243343.0
2009-09-23 09:00:00	QQQ	ETF	42.83	42.85	42.81	42.84	281242.0
2009-09-23 09:30:00	QQQ	ETF	42.83	42.86	42.7	42.72	14668653.0
2009-09-23 10:00:00	QQQ	ETF	42.72	42.84	42.68	42.792	8272978.0
2009-09-23 10:30:00	QQQ	ETF	42.79	42.82	42.61	42.71	8040325.0
2009-09-23 11:00:00	QQQ	ETF	42.7	42.72	42.63	42.71	2302093.0
2009-09-23 11:30:00	QQQ	ETF	42.71	42.81	42.7	42.8	2791101.0
2009-09-23 12:00:00	QQQ	ETF	42.8	42.86	42.79	42.84	3327108.0
2009-09-23 12:30:00	QQQ	ETF	42.84	42.88	42.77	42.84	2724997.0
2009-09-23 13:00:00	QQQ	ETF	42.83	42.87	42.782	42.7998	2794563.0
2009-09-23 13:30:00	QQQ	ETF	42.8	42.89	42.79	42.8649	3014472.0
2009-09-23 14:00:00	QQQ	ETF	42.86	43.06	42.8	43.0	15372856.0

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

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