PREVIEW / etf_30min / 2007-03-05

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-03-05.parquet
  size:    123 KB
  rows:    4,273

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-05 04:00:00	SPY	ETF	137.99	137.99	137.65	137.65	4700.0
2007-03-05 04:30:00	SPY	ETF	137.67	137.73	137.65	137.72	15300.0
2007-03-05 05:00:00	SPY	ETF	137.69	137.69	137.56	137.56	15000.0
2007-03-05 05:30:00	SPY	ETF	137.46	137.48	137.41	137.45	18500.0
2007-03-05 06:00:00	SPY	ETF	137.61	137.61	137.53	137.56	31000.0
2007-03-05 06:30:00	SPY	ETF	137.6	137.81	137.6	137.79	87800.0
2007-03-05 07:00:00	SPY	ETF	137.75	137.81	137.47	137.47	698500.0
2007-03-05 07:30:00	SPY	ETF	137.47	137.77	137.39	137.72	1191600.0
2007-03-05 08:00:00	SPY	ETF	137.7	138.55	137.42	137.73	3906400.0
2007-03-05 08:30:00	SPY	ETF	137.72	138.17	137.71	138.07	1817400.0
2007-03-05 09:00:00	SPY	ETF	138.08	138.23	137.93	137.93	3407600.0
2007-03-05 09:30:00	SPY	ETF	137.93	138.86	137.82	138.85	18274601.0
2007-03-05 10:00:00	SPY	ETF	138.85	139.58	138.31	138.95	20214900.0
2007-03-05 10:30:00	SPY	ETF	138.95	139.1	138.57	139.09	8313100.0
2007-03-05 11:00:00	SPY	ETF	139.1	139.52	138.94	139.24	10303800.0
2007-03-05 11:30:00	SPY	ETF	139.24	139.26	138.57	138.59	7550300.0
2007-03-05 12:00:00	SPY	ETF	138.59	138.68	138.15	138.48	7247500.0
2007-03-05 12:30:00	SPY	ETF	138.49	138.71	138.26	138.4	5767300.0
2007-03-05 13:00:00	SPY	ETF	138.41	138.6	138.28	138.49	3787500.0
2007-03-05 13:30:00	SPY	ETF	138.49	139.0	138.44	138.86	5570100.0
2007-03-05 14:00:00	SPY	ETF	138.86	139.09	138.56	138.6	6138400.0
2007-03-05 14:30:00	SPY	ETF	138.59	138.83	138.55	138.65	3894000.0
2007-03-05 15:00:00	SPY	ETF	138.6475	139.014	138.02	138.54	11381800.0
2007-03-05 15:30:00	SPY	ETF	138.55	138.6	137.66	137.69	14730100.0
2007-03-05 16:00:00	SPY	ETF	137.66	137.66	137.34	137.37	3487300.0
2007-03-05 16:30:00	SPY	ETF	137.37	137.64	137.37	137.5	963700.0
2007-03-05 17:00:00	SPY	ETF	137.5	139.7	137.17	137.21	546700.0
2007-03-05 17:30:00	SPY	ETF	138.489	139.301	137.2	137.699	174800.0
2007-03-05 18:00:00	SPY	ETF	138.079	139.299	137.08	137.4	418700.0
2007-03-05 18:30:00	SPY	ETF	137.37	137.68	137.37	137.68	54300.0
2007-03-05 19:00:00	SPY	ETF	137.67	137.93	137.67	137.9	20200.0
2007-03-05 19:30:00	SPY	ETF	137.88	139.02	137.87	137.87	568800.0
2007-03-05 04:00:00	QQQ	ETF	42.05	42.05	42.02	42.03	1300.0
2007-03-05 05:00:00	QQQ	ETF	42.03	42.03	41.99	41.99	1600.0
2007-03-05 05:30:00	QQQ	ETF	41.96	41.96	41.96	41.96	100.0
2007-03-05 06:00:00	QQQ	ETF	41.96	42.0	41.94	41.96	68900.0
2007-03-05 06:30:00	QQQ	ETF	42.0	42.08	42.0	42.08	15700.0
2007-03-05 07:00:00	QQQ	ETF	42.07	42.07	41.95	41.95	191097.0
2007-03-05 07:30:00	QQQ	ETF	41.95	42.11	41.89	42.1	912509.0
2007-03-05 08:00:00	QQQ	ETF	42.1	42.12	41.92	42.0	1595316.0
2007-03-05 08:30:00	QQQ	ETF	42.0	42.16	41.97	42.15	2059826.0
2007-03-05 09:00:00	QQQ	ETF	42.14	42.2	42.09	42.18	2128265.0
2007-03-05 09:30:00	QQQ	ETF	42.16	42.51	41.65	42.51	32682800.0
2007-03-05 10:00:00	QQQ	ETF	42.52	42.8	42.25	42.56	23628700.0
2007-03-05 10:30:00	QQQ	ETF	42.57	42.67	42.37	42.53	11136600.0
2007-03-05 11:00:00	QQQ	ETF	42.53	42.7	42.49	42.6	8296200.0
2007-03-05 11:30:00	QQQ	ETF	42.6	42.63	42.36	42.37	8572300.0
2007-03-05 12:00:00	QQQ	ETF	42.37	42.42	42.31	42.35	6402800.0
2007-03-05 12:30:00	QQQ	ETF	42.35	42.41	42.26	42.3	7052500.0
2007-03-05 13:00:00	QQQ	ETF	42.3	42.37	42.27	42.36	5856100.0

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

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