PREVIEW / etf_30min / 2007-10-16

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-10-16.parquet
  size:    128 KB
  rows:    4,831

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
2007-10-16 04:00:00	SPY	ETF	154.11	154.11	154.11	154.11	100.0
2007-10-16 04:30:00	SPY	ETF	154.19	154.19	154.19	154.19	100.0
2007-10-16 05:00:00	SPY	ETF	154.26	154.26	154.24	154.25	5000.0
2007-10-16 05:30:00	SPY	ETF	154.24	154.31	154.24	154.31	15600.0
2007-10-16 06:00:00	SPY	ETF	154.29	154.29	154.28	154.28	1100.0
2007-10-16 06:30:00	SPY	ETF	154.26	154.29	154.16	154.29	73200.0
2007-10-16 07:00:00	SPY	ETF	154.34	154.36	154.23	154.28	217000.0
2007-10-16 07:30:00	SPY	ETF	154.28	154.3	154.13	154.25	788000.0
2007-10-16 08:00:00	SPY	ETF	154.24	154.29	154.18	154.24	979300.0
2007-10-16 08:30:00	SPY	ETF	154.25	154.56	154.2	154.49	900100.0
2007-10-16 09:00:00	SPY	ETF	154.51	154.51	154.27	154.42	1252028.0
2007-10-16 09:30:00	SPY	ETF	154.41	156.48	153.97	154.21	20991644.0
2007-10-16 10:00:00	SPY	ETF	154.21	154.39	153.55	153.71	17058041.0
2007-10-16 10:30:00	SPY	ETF	153.71	154.08	153.6	154.04	14550266.0
2007-10-16 11:00:00	SPY	ETF	154.04	154.19	153.89	154.14	10755800.0
2007-10-16 11:30:00	SPY	ETF	154.13	154.52	154.01	154.06	11486739.0
2007-10-16 12:00:00	SPY	ETF	154.06	154.23	153.9	154.09	5785477.0
2007-10-16 12:30:00	SPY	ETF	154.09	154.31	154.01	154.215	4846000.0
2007-10-16 13:00:00	SPY	ETF	154.21	154.22	153.71	153.91	9148600.0
2007-10-16 13:30:00	SPY	ETF	153.91	154.18	153.74	154.01	7371126.0
2007-10-16 14:00:00	SPY	ETF	154.01	154.21	153.82	153.86	8341100.0
2007-10-16 14:30:00	SPY	ETF	153.86	154.01	153.58	153.8	9813300.0
2007-10-16 15:00:00	SPY	ETF	153.8	153.92	153.47	153.69	11280600.0
2007-10-16 15:30:00	SPY	ETF	153.69	154.12	153.54	153.7608	15764105.0
2007-10-16 16:00:00	SPY	ETF	153.75	154.08	153.62	153.96	5807700.0
2007-10-16 16:30:00	SPY	ETF	153.94	154.44	153.87	154.3	2443900.0
2007-10-16 17:00:00	SPY	ETF	154.31	154.43	154.3	154.34	180100.0
2007-10-16 17:30:00	SPY	ETF	154.34	154.42	154.28	154.35	23600.0
2007-10-16 18:00:00	SPY	ETF	154.33	154.44	154.31	154.41	120100.0
2007-10-16 18:30:00	SPY	ETF	154.41	154.5	154.4	154.46	58200.0
2007-10-16 19:00:00	SPY	ETF	154.44	154.44	154.3	154.3	67400.0
2007-10-16 19:30:00	SPY	ETF	154.33	154.36	154.33	154.35	3700.0
2007-10-16 04:00:00	QQQ	ETF	52.81	52.82	52.81	52.82	500.0
2007-10-16 04:30:00	QQQ	ETF	52.8	52.8	52.8	52.8	500.0
2007-10-16 05:00:00	QQQ	ETF	52.84	52.84	52.83	52.83	200.0
2007-10-16 05:30:00	QQQ	ETF	52.84	52.84	52.84	52.84	300.0
2007-10-16 06:00:00	QQQ	ETF	52.85	52.85	52.85	52.85	200.0
2007-10-16 06:30:00	QQQ	ETF	52.87	52.88	52.8	52.88	53700.0
2007-10-16 07:00:00	QQQ	ETF	52.87	52.88	52.82	52.84	124988.0
2007-10-16 07:30:00	QQQ	ETF	52.84	52.84	52.76	52.77	539959.0
2007-10-16 08:00:00	QQQ	ETF	52.8	52.81	52.76	52.79	1321305.0
2007-10-16 08:30:00	QQQ	ETF	52.8	52.93	52.76	52.91	1317158.0
2007-10-16 09:00:00	QQQ	ETF	52.91	52.91	52.79	52.8	1013138.0
2007-10-16 09:30:00	QQQ	ETF	52.79	52.95	52.68	52.95	19225387.0
2007-10-16 10:00:00	QQQ	ETF	52.9485	53.08	52.747	52.83	26411256.0
2007-10-16 10:30:00	QQQ	ETF	52.8285	52.97	52.78	52.93	13424747.0
2007-10-16 11:00:00	QQQ	ETF	52.93	53.14	52.91	53.1	15370532.0
2007-10-16 11:30:00	QQQ	ETF	53.1	53.28	53.0901	53.16	12785160.0
2007-10-16 12:00:00	QQQ	ETF	53.15	53.2	53.01	53.05	8044977.0
2007-10-16 12:30:00	QQQ	ETF	53.06	53.15	53.0	53.09	5566249.0

> showing 50 of 4,831 rows — these rows as CSV

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