PREVIEW / etf_30min / 2007-06-01

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-06-01.parquet
  size:    56 KB
  rows:    1,798

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-06-01 04:30:00	SPY	ETF	153.7	153.7	153.7	153.7	200.0
2007-06-01 06:00:00	SPY	ETF	153.83	153.83	153.83	153.83	12500.0
2007-06-01 06:30:00	SPY	ETF	153.82	153.82	153.82	153.82	3000.0
2007-06-01 07:00:00	SPY	ETF	153.8	153.84	153.74	153.76	158500.0
2007-06-01 07:30:00	SPY	ETF	153.75	153.8	153.75	153.77	263200.0
2007-06-01 08:00:00	SPY	ETF	153.765	153.81	153.65	153.72	1734100.0
2007-06-01 08:30:00	SPY	ETF	153.74	154.16	153.68	153.96	5127600.0
2007-06-01 09:00:00	SPY	ETF	153.97	154.0	153.88	153.9	798313.0
2007-06-01 09:30:00	SPY	ETF	153.88	154.19	153.85	154.08	16431904.0
2007-06-01 10:00:00	SPY	ETF	154.08	154.4	153.93	154.0	16305488.0
2007-06-01 10:30:00	SPY	ETF	154.01	154.08	153.75	153.86	8159745.0
2007-06-01 11:00:00	SPY	ETF	153.86	154.03	153.82	153.97	7403400.0
2007-06-01 11:30:00	SPY	ETF	153.97	154.11	153.9	153.95	3362234.0
2007-06-01 12:00:00	SPY	ETF	153.96	153.98	153.56	153.73	7660400.0
2007-06-01 12:30:00	SPY	ETF	153.72	153.78	153.51	153.73	5277415.0
2007-06-01 13:00:00	SPY	ETF	153.73	154.0	153.63	153.91	6242623.0
2007-06-01 13:30:00	SPY	ETF	153.91	153.98	153.87	153.9	3325890.0
2007-06-01 14:00:00	SPY	ETF	153.91	153.96	153.72	153.84	2324989.0
2007-06-01 14:30:00	SPY	ETF	153.84	153.86	153.75	153.8	3361104.0
2007-06-01 15:00:00	SPY	ETF	153.81	153.84	153.62	153.74	4773602.0
2007-06-01 15:30:00	SPY	ETF	153.75	153.98	153.52	153.96	9609312.0
2007-06-01 16:00:00	SPY	ETF	153.98	154.11	153.89	153.98	4060800.0
2007-06-01 16:30:00	SPY	ETF	153.98	154.0	153.93	153.93	83800.0
2007-06-01 17:00:00	SPY	ETF	153.96	153.97	153.93	153.93	37000.0
2007-06-01 17:30:00	SPY	ETF	153.97	153.98	153.97	153.98	4500.0
2007-06-01 18:00:00	SPY	ETF	153.98	153.98	153.97	153.97	1200.0
2007-06-01 18:30:00	SPY	ETF	153.97	153.98	153.97	153.98	3800.0
2007-06-01 19:00:00	SPY	ETF	153.97	153.97	153.9	153.96	32900.0
2007-06-01 19:30:00	SPY	ETF	153.91	153.91	153.88	153.88	5100.0
2007-06-01 04:00:00	QQQ	ETF	47.54	47.54	47.54	47.54	100.0
2007-06-01 04:30:00	QQQ	ETF	47.55	47.55	47.55	47.55	2742.0
2007-06-01 07:00:00	QQQ	ETF	47.57	47.57	47.54	47.55	39200.0
2007-06-01 07:30:00	QQQ	ETF	47.56	47.58	47.56	47.57	60950.0
2007-06-01 08:00:00	QQQ	ETF	47.58	47.58	47.54	47.58	1322809.0
2007-06-01 08:30:00	QQQ	ETF	47.57	47.72	47.41	47.68	4423605.0
2007-06-01 09:00:00	QQQ	ETF	47.68	47.68	47.58	47.58	1210542.0
2007-06-01 09:30:00	QQQ	ETF	47.58	47.71	47.57	47.67	9462798.0
2007-06-01 10:00:00	QQQ	ETF	47.67	47.77	47.54	47.58	16161133.0
2007-06-01 10:30:00	QQQ	ETF	47.58	47.62	47.48	47.5497	8315349.0
2007-06-01 11:00:00	QQQ	ETF	47.5499	47.62	47.52	47.57	5946705.0
2007-06-01 11:30:00	QQQ	ETF	47.56	47.6	47.54	47.57	2135398.0
2007-06-01 12:00:00	QQQ	ETF	47.56	47.58	47.37	47.46	14157138.0
2007-06-01 12:30:00	QQQ	ETF	47.46	47.5	47.37	47.45	6196925.0
2007-06-01 13:00:00	QQQ	ETF	47.45	47.55	47.39	47.54	5473226.0
2007-06-01 13:30:00	QQQ	ETF	47.54	47.58	47.52	47.5401	3205920.0
2007-06-01 14:00:00	QQQ	ETF	47.54	47.58	47.48	47.52	2015276.0
2007-06-01 14:30:00	QQQ	ETF	47.5295	47.56	47.45	47.55	12100753.0
2007-06-01 15:00:00	QQQ	ETF	47.54	47.56	47.46	47.5	9528590.0
2007-06-01 15:30:00	QQQ	ETF	47.5	47.55	47.42	47.43	14747468.0
2007-06-01 16:00:00	QQQ	ETF	47.43	47.49	47.42	47.44	8239159.0

> showing 50 of 1,798 rows — these rows as CSV

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