PREVIEW / etf_30min / 2007-02-28

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-02-28.parquet
  size:    107 KB
  rows:    3,742

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-02-28 04:00:00	SPY	ETF	140.92	140.92	140.87	140.87	1000.0
2007-02-28 04:30:00	SPY	ETF	140.8	141.0	140.8	141.0	1100.0
2007-02-28 05:30:00	SPY	ETF	141.02	141.03	140.92	140.92	118500.0
2007-02-28 06:00:00	SPY	ETF	140.83	141.11	140.78	141.11	32100.0
2007-02-28 06:30:00	SPY	ETF	141.18	141.18	140.62	140.64	131100.0
2007-02-28 07:00:00	SPY	ETF	140.65	140.68	140.32	140.56	550000.0
2007-02-28 07:30:00	SPY	ETF	140.55	140.88	140.54	140.78	1319700.0
2007-02-28 08:00:00	SPY	ETF	140.77	141.1	139.8	140.62	4472600.0
2007-02-28 08:30:00	SPY	ETF	140.56	141.1	140.38	140.49	3808400.0
2007-02-28 09:00:00	SPY	ETF	140.49	140.89	140.37	140.39	3319400.0
2007-02-28 09:30:00	SPY	ETF	140.39	141.08	139.8	140.68	35868500.0
2007-02-28 10:00:00	SPY	ETF	140.69	141.25	140.27	140.88	23958500.0
2007-02-28 10:30:00	SPY	ETF	140.88	141.98	140.79	141.5	24454400.0
2007-02-28 11:00:00	SPY	ETF	141.58	141.75	141.29	141.51	13893000.0
2007-02-28 11:30:00	SPY	ETF	141.5	141.6	140.94	140.98	8839800.0
2007-02-28 12:00:00	SPY	ETF	140.98	141.33	140.72	141.06	8319900.0
2007-02-28 12:30:00	SPY	ETF	141.07	141.55	141.0	141.42	4412400.0
2007-02-28 13:00:00	SPY	ETF	141.42	141.57	140.99	141.5	4764500.0
2007-02-28 13:30:00	SPY	ETF	141.51	141.57	140.83	140.96	4334900.0
2007-02-28 14:00:00	SPY	ETF	141.01	141.29	140.71	140.89	6244400.0
2007-02-28 14:30:00	SPY	ETF	140.9	141.18	140.8	141.0	5340800.0
2007-02-28 15:00:00	SPY	ETF	141.0	141.5	140.95	141.35	6863600.0
2007-02-28 15:30:00	SPY	ETF	141.35	141.44	140.88	140.91	9220600.0
2007-02-28 16:00:00	SPY	ETF	140.96	141.09	140.56	140.96	1717900.0
2007-02-28 16:30:00	SPY	ETF	140.94	140.98	140.81	140.82	241200.0
2007-02-28 17:00:00	SPY	ETF	140.82	140.87	140.81	140.82	25600.0
2007-02-28 17:30:00	SPY	ETF	140.81	140.89	140.8	140.88	3300.0
2007-02-28 18:00:00	SPY	ETF	140.88	141.0	140.88	140.96	12900.0
2007-02-28 18:30:00	SPY	ETF	140.96	140.96	140.9	140.9	600.0
2007-02-28 19:00:00	SPY	ETF	140.86	140.86	140.79	140.8	2000.0
2007-02-28 19:30:00	SPY	ETF	140.78	140.81	140.78	140.81	22200.0
2007-02-28 04:30:00	QQQ	ETF	43.28	43.3	43.28	43.3	500.0
2007-02-28 05:00:00	QQQ	ETF	43.41	43.41	43.41	43.41	100.0
2007-02-28 05:30:00	QQQ	ETF	43.4	43.4	43.36	43.36	4000.0
2007-02-28 06:00:00	QQQ	ETF	43.35	43.35	43.35	43.35	3000.0
2007-02-28 06:30:00	QQQ	ETF	43.4	43.42	43.3	43.33	90630.0
2007-02-28 07:00:00	QQQ	ETF	43.31	43.35	43.17	43.24	736135.0
2007-02-28 07:30:00	QQQ	ETF	43.23	43.35	43.21	43.33	1425305.0
2007-02-28 08:00:00	QQQ	ETF	43.33	43.4	43.26	43.32	3510506.0
2007-02-28 08:30:00	QQQ	ETF	43.31	43.5	43.22	43.3	2889480.0
2007-02-28 09:00:00	QQQ	ETF	43.29	43.37	43.16	43.16	3223853.0
2007-02-28 09:30:00	QQQ	ETF	43.16	43.41	42.93	43.19	43825400.0
2007-02-28 10:00:00	QQQ	ETF	43.19	43.47	43.08	43.45	28953300.0
2007-02-28 10:30:00	QQQ	ETF	43.46	43.76	43.04	43.59	30618100.0
2007-02-28 11:00:00	QQQ	ETF	43.59	43.67	43.51	43.54	10348800.0
2007-02-28 11:30:00	QQQ	ETF	43.53	43.55	43.3	43.35	10954100.0
2007-02-28 12:00:00	QQQ	ETF	43.35	43.5	43.25	43.41	10257800.0
2007-02-28 12:30:00	QQQ	ETF	43.4	43.58	43.39	43.54	5584100.0
2007-02-28 13:00:00	QQQ	ETF	43.54	43.6	43.2	43.54	9116100.0
2007-02-28 13:30:00	QQQ	ETF	43.54	43.55	43.37	43.43	7042800.0

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

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