PREVIEW / etf_30min / 2006-03-27

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-03-27.parquet
  size:    57 KB
  rows:    2,137

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
2006-03-27 06:30:00	SPY	ETF	130.29	130.29	130.29	130.29	2000.0
2006-03-27 07:30:00	SPY	ETF	130.32	130.39	130.31	130.36	8500.0
2006-03-27 08:00:00	SPY	ETF	130.37	130.41	130.31	130.32	69100.0
2006-03-27 08:30:00	SPY	ETF	130.34	130.34	130.22	130.23	164300.0
2006-03-27 09:00:00	SPY	ETF	130.21	130.21	129.99	130.02	321600.0
2006-03-27 09:30:00	SPY	ETF	130.03	130.2	129.91	130.14	4621200.0
2006-03-27 10:00:00	SPY	ETF	130.14	130.18	129.88	129.99	3561300.0
2006-03-27 10:30:00	SPY	ETF	129.99	130.05	129.86	129.93	1762500.0
2006-03-27 11:00:00	SPY	ETF	129.92	129.98	129.78	129.84	2672500.0
2006-03-27 11:30:00	SPY	ETF	129.84	130.0	129.8	129.88	1357000.0
2006-03-27 12:00:00	SPY	ETF	129.88	129.93	129.74	129.88	1154200.0
2006-03-27 12:30:00	SPY	ETF	129.89	130.06	129.87	129.98	1378900.0
2006-03-27 13:00:00	SPY	ETF	129.98	130.2	129.98	130.04	2219900.0
2006-03-27 13:30:00	SPY	ETF	130.04	130.13	129.96	130.09	2224300.0
2006-03-27 14:00:00	SPY	ETF	130.09	130.13	129.99	130.12	968600.0
2006-03-27 14:30:00	SPY	ETF	130.12	130.28	130.1	130.22	2426500.0
2006-03-27 15:00:00	SPY	ETF	130.23	130.26	130.06	130.13	2425500.0
2006-03-27 15:30:00	SPY	ETF	130.13	130.22	130.04	130.08	2697800.0
2006-03-27 16:00:00	SPY	ETF	130.11	130.11	130.02	130.08	1142100.0
2006-03-27 16:30:00	SPY	ETF	130.08	130.08	130.0054	130.03	96100.0
2006-03-27 17:00:00	SPY	ETF	130.04	130.07	130.04	130.07	2900.0
2006-03-27 17:30:00	SPY	ETF	130.03	130.08	130.03	130.08	50100.0
2006-03-27 18:00:00	SPY	ETF	130.05	130.05	130.05	130.05	100.0
2006-03-27 19:00:00	SPY	ETF	130.01	130.01	129.98	129.98	5700.0
2006-03-27 19:30:00	SPY	ETF	129.97	129.97	129.97	129.97	500.0
2006-03-27 09:30:00	QQQ	ETF	41.28	41.51	41.25	41.44	7404700.0
2006-03-27 10:00:00	QQQ	ETF	41.44	41.47	41.33	41.4	7497900.0
2006-03-27 10:30:00	QQQ	ETF	41.39	41.45	41.32	41.33	3376300.0
2006-03-27 11:00:00	QQQ	ETF	41.34	41.38	41.24	41.28	6707100.0
2006-03-27 11:30:00	QQQ	ETF	41.29	41.38	41.27	41.33	3615700.0
2006-03-27 12:00:00	QQQ	ETF	41.33	41.35	41.27	41.31	1949100.0
2006-03-27 12:30:00	QQQ	ETF	41.3	41.45	41.3	41.37	3564100.0
2006-03-27 13:00:00	QQQ	ETF	41.36	41.44	41.36	41.38	2620000.0
2006-03-27 13:30:00	QQQ	ETF	41.39	41.42	41.32	41.4	2576000.0
2006-03-27 14:00:00	QQQ	ETF	41.4	41.42	41.34	41.4	1790100.0
2006-03-27 14:30:00	QQQ	ETF	41.4	41.43	41.38	41.41	1731700.0
2006-03-27 15:00:00	QQQ	ETF	41.4	41.42	41.34	41.35	2775900.0
2006-03-27 15:30:00	QQQ	ETF	41.35	41.38	41.29	41.33	4830600.0
2006-03-27 08:00:00	IWM	ETF	75.01	75.01	74.93	74.97	6500.0
2006-03-27 08:30:00	IWM	ETF	74.96	74.96	74.88	74.88	13000.0
2006-03-27 09:00:00	IWM	ETF	74.86	74.88	74.79	74.82	220800.0
2006-03-27 09:30:00	IWM	ETF	74.81	74.87	74.66	74.74	3274200.0
2006-03-27 10:00:00	IWM	ETF	74.75	74.81	74.51	74.62	3529900.0
2006-03-27 10:30:00	IWM	ETF	74.62	74.71	74.55	74.6	1132600.0
2006-03-27 11:00:00	IWM	ETF	74.59	74.62	74.42	74.43	1908200.0
2006-03-27 11:30:00	IWM	ETF	74.43	74.69	74.42	74.65	1334400.0
2006-03-27 12:00:00	IWM	ETF	74.6499	74.69	74.56	74.64	909600.0
2006-03-27 12:30:00	IWM	ETF	74.64	74.8	74.62	74.75	1202600.0
2006-03-27 13:00:00	IWM	ETF	74.75	74.85	74.73	74.77	1796100.0
2006-03-27 13:30:00	IWM	ETF	74.77	74.88	74.74	74.85	928800.0

> showing 50 of 2,137 rows — these rows as CSV

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