PREVIEW / etf_30min / 2007-03-26

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-03-26.parquet
  size:    111 KB
  rows:    3,895

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-03-26 05:00:00	SPY	ETF	143.33	143.33	143.33	143.33	2200.0
2007-03-26 06:30:00	SPY	ETF	143.41	143.41	143.41	143.41	3000.0
2007-03-26 07:00:00	SPY	ETF	143.41	143.51	143.35	143.48	47300.0
2007-03-26 07:30:00	SPY	ETF	143.46	143.55	143.45	143.45	47900.0
2007-03-26 08:00:00	SPY	ETF	143.45	143.46	143.42	143.43	38700.0
2007-03-26 08:30:00	SPY	ETF	143.43	143.45	143.4	143.45	100800.0
2007-03-26 09:00:00	SPY	ETF	143.46	143.52	143.39	143.51	338100.0
2007-03-26 09:30:00	SPY	ETF	143.5	143.53	143.25	143.49	6267801.0
2007-03-26 10:00:00	SPY	ETF	143.48	143.49	142.18	142.18	34358363.0
2007-03-26 10:30:00	SPY	ETF	142.2	142.7	142.12	142.5	11355257.0
2007-03-26 11:00:00	SPY	ETF	142.5	142.59	142.09	142.5	7671583.0
2007-03-26 11:30:00	SPY	ETF	142.49	142.77	142.47	142.62	5336921.0
2007-03-26 12:00:00	SPY	ETF	142.64	143.0	142.6	142.9	5964500.0
2007-03-26 12:30:00	SPY	ETF	142.8985	143.02	142.78	142.79	5515063.0
2007-03-26 13:00:00	SPY	ETF	142.78	142.86	142.69	142.79	2775393.0
2007-03-26 13:30:00	SPY	ETF	142.795	143.02	142.795	142.96	3907539.0
2007-03-26 14:00:00	SPY	ETF	142.97	143.18	142.97	143.1	5889134.0
2007-03-26 14:30:00	SPY	ETF	143.1	143.15	142.96	143.15	3186169.0
2007-03-26 15:00:00	SPY	ETF	143.14	143.4553	142.95	143.28	6312800.0
2007-03-26 15:30:00	SPY	ETF	143.28	143.65	143.27	143.59	10858308.0
2007-03-26 16:00:00	SPY	ETF	143.57	143.5985	143.0279	143.23	2448300.0
2007-03-26 16:30:00	SPY	ETF	143.25	143.3	143.25	143.3	127000.0
2007-03-26 17:00:00	SPY	ETF	143.29	143.5985	142.62	143.22	64700.0
2007-03-26 17:30:00	SPY	ETF	143.23	143.24	143.23	143.24	4500.0
2007-03-26 18:00:00	SPY	ETF	143.22	143.23	143.19	143.2	19500.0
2007-03-26 18:30:00	SPY	ETF	143.2	143.24	143.2	143.23	4100.0
2007-03-26 19:00:00	SPY	ETF	143.21	143.21	143.2	143.2	1800.0
2007-03-26 19:30:00	SPY	ETF	143.23	143.23	143.23	143.23	500.0
2007-03-26 07:00:00	QQQ	ETF	44.1	44.2	44.1	44.2	70667.0
2007-03-26 07:30:00	QQQ	ETF	44.17	44.22	44.17	44.17	51642.0
2007-03-26 08:00:00	QQQ	ETF	44.15	44.17	44.13	44.16	105064.0
2007-03-26 08:30:00	QQQ	ETF	44.16	44.18	44.14	44.18	263955.0
2007-03-26 09:00:00	QQQ	ETF	44.18	44.19	44.15	44.15	263714.0
2007-03-26 09:30:00	QQQ	ETF	44.15	44.23	44.09	44.21	6688200.0
2007-03-26 10:00:00	QQQ	ETF	44.2	44.2	43.63	43.67	26563100.0
2007-03-26 10:30:00	QQQ	ETF	43.68	44.66	43.66	43.83	15422800.0
2007-03-26 11:00:00	QQQ	ETF	43.81	43.89	43.71	43.85	6831100.0
2007-03-26 11:30:00	QQQ	ETF	43.85	43.96	43.85	43.87	7532000.0
2007-03-26 12:00:00	QQQ	ETF	43.87	43.99	43.85	43.96	3836300.0
2007-03-26 12:30:00	QQQ	ETF	43.96	44.01	43.92	43.92	2997000.0
2007-03-26 13:00:00	QQQ	ETF	43.92	43.95	43.89	43.92	4881900.0
2007-03-26 13:30:00	QQQ	ETF	43.93	44.02	43.93	43.98	4440800.0
2007-03-26 14:00:00	QQQ	ETF	43.98	44.13	43.98	44.09	6583000.0
2007-03-26 14:30:00	QQQ	ETF	44.09	44.12	44.03	44.12	3397300.0
2007-03-26 15:00:00	QQQ	ETF	44.12	44.18	44.09	44.16	4284200.0
2007-03-26 15:30:00	QQQ	ETF	44.17	44.32	44.15	44.32	9915300.0
2007-03-26 16:00:00	QQQ	ETF	44.31	44.32	44.03	44.23	4428710.0
2007-03-26 16:30:00	QQQ	ETF	44.22	44.25	44.22	44.25	235581.0
2007-03-26 17:00:00	QQQ	ETF	44.25	44.317	43.85	44.2601	1551372.0
2007-03-26 17:30:00	QQQ	ETF	44.22	44.24	44.22	44.22	6700.0

> showing 50 of 3,895 rows — these rows as CSV

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