PREVIEW / etf_30min / 2008-04-04

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-04-04.parquet
  size:    156 KB
  rows:    5,641

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
2008-04-04 05:30:00	SPY	ETF	137.07	137.07	137.07	137.07	10000.0
2008-04-04 07:00:00	SPY	ETF	137.04	137.36	137.04	137.36	531300.0
2008-04-04 07:30:00	SPY	ETF	137.33	137.83	137.3	137.72	996900.0
2008-04-04 08:00:00	SPY	ETF	137.72	138.28	136.95	137.9	6117618.0
2008-04-04 08:30:00	SPY	ETF	137.9	137.9	136.53	137.46	16342413.0
2008-04-04 09:00:00	SPY	ETF	137.45	137.5	136.93	136.93	3117269.0
2008-04-04 09:30:00	SPY	ETF	136.95	137.03	136.46	136.78	23509414.0
2008-04-04 10:00:00	SPY	ETF	136.78	137.0	136.18	136.4895	16505752.0
2008-04-04 10:30:00	SPY	ETF	136.48	136.74	136.12	136.69	11756109.0
2008-04-04 11:00:00	SPY	ETF	136.69	137.13	136.66	137.1	14206226.0
2008-04-04 11:30:00	SPY	ETF	137.1	137.25	136.82	136.84	8952427.0
2008-04-04 12:00:00	SPY	ETF	136.85	137.53	136.8	137.49	11441175.0
2008-04-04 12:30:00	SPY	ETF	137.49	137.81	137.37	137.72	9084834.0
2008-04-04 13:00:00	SPY	ETF	137.73	137.94	137.54	137.93	8868299.0
2008-04-04 13:30:00	SPY	ETF	137.94	137.96	137.51	137.65	7188427.0
2008-04-04 14:00:00	SPY	ETF	137.65	137.75	137.17	137.3	10328154.0
2008-04-04 14:30:00	SPY	ETF	137.29	137.67	137.19	137.43	8664114.0
2008-04-04 15:00:00	SPY	ETF	137.43	137.58	136.84	136.95	13604482.0
2008-04-04 15:30:00	SPY	ETF	136.95	137.1	136.55	136.97	19084673.0
2008-04-04 16:00:00	SPY	ETF	136.9199	137.42	136.28	136.78	5959000.0
2008-04-04 16:30:00	SPY	ETF	136.78	136.89	136.73	136.86	1024300.0
2008-04-04 17:00:00	SPY	ETF	136.84	136.98	136.8	136.95	4010900.0
2008-04-04 17:30:00	SPY	ETF	136.95	137.1	136.95	137.1	19200.0
2008-04-04 18:00:00	SPY	ETF	137.01	137.01	136.9	136.92	5200.0
2008-04-04 18:30:00	SPY	ETF	136.92	136.92	136.86	136.9	23300.0
2008-04-04 19:00:00	SPY	ETF	136.88	136.88	136.88	136.88	300.0
2008-04-04 19:30:00	SPY	ETF	136.93	137.04	136.93	137.04	1900.0
2008-04-04 06:00:00	QQQ	ETF	45.79	45.79	45.77	45.77	10300.0
2008-04-04 06:30:00	QQQ	ETF	45.8	45.8	45.76	45.77	2200.0
2008-04-04 07:00:00	QQQ	ETF	45.82	45.91	45.8	45.89	247322.0
2008-04-04 07:30:00	QQQ	ETF	45.9	45.99	45.85	45.99	218813.0
2008-04-04 08:00:00	QQQ	ETF	45.98	46.06	45.81	46.0	2874540.0
2008-04-04 08:30:00	QQQ	ETF	45.96	45.96	45.63	45.91	7315711.0
2008-04-04 09:00:00	QQQ	ETF	45.92	45.93	45.77	45.78	952268.0
2008-04-04 09:30:00	QQQ	ETF	45.77	45.87	45.59	45.78	14988192.0
2008-04-04 10:00:00	QQQ	ETF	45.7775	45.82	45.4	45.63	11608785.0
2008-04-04 10:30:00	QQQ	ETF	45.63	45.65	45.43	45.64	11588136.0
2008-04-04 11:00:00	QQQ	ETF	45.65	45.84	45.64	45.82	9228689.0
2008-04-04 11:30:00	QQQ	ETF	45.82	45.86	45.74	45.76	4340422.0
2008-04-04 12:00:00	QQQ	ETF	45.77	46.06	45.75	45.99	14688881.0
2008-04-04 12:30:00	QQQ	ETF	45.98	46.21	45.95	46.17	7008967.0
2008-04-04 13:00:00	QQQ	ETF	46.18	46.34	46.11	46.34	6929084.0
2008-04-04 13:30:00	QQQ	ETF	46.3401	46.35	46.17	46.19	4768431.0
2008-04-04 14:00:00	QQQ	ETF	46.182	46.24	46.04	46.1005	11313552.0
2008-04-04 14:30:00	QQQ	ETF	46.11	46.19	46.01	46.06	4470788.0
2008-04-04 15:00:00	QQQ	ETF	46.07	46.12	45.79	45.85	10887920.0
2008-04-04 15:30:00	QQQ	ETF	45.85	45.92	45.77	45.87	13689193.0
2008-04-04 16:00:00	QQQ	ETF	45.86	45.9025	45.4293	45.81	1646582.0
2008-04-04 16:30:00	QQQ	ETF	45.84	45.87	45.82	45.82	68500.0
2008-04-04 17:00:00	QQQ	ETF	45.81	45.83	45.75	45.8	221584.0

> showing 50 of 5,641 rows — these rows as CSV

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