PREVIEW / etf_30min / 2008-07-02

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-07-02.parquet
  size:    175 KB
  rows:    5,946

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-07-02 04:30:00	SPY	ETF	128.67	128.67	128.67	128.67	1000.0
2008-07-02 05:30:00	SPY	ETF	128.73	129.0	128.71	129.0	2300.0
2008-07-02 06:00:00	SPY	ETF	129.04	129.21	129.0	129.0	148500.0
2008-07-02 06:30:00	SPY	ETF	129.0	129.2	128.84	129.14	146500.0
2008-07-02 07:00:00	SPY	ETF	129.11	129.27	129.1	129.25	645050.0
2008-07-02 07:30:00	SPY	ETF	129.25	129.28	129.15	129.16	576275.0
2008-07-02 08:00:00	SPY	ETF	129.16	129.28	128.7	129.0	3329470.0
2008-07-02 08:30:00	SPY	ETF	128.96	129.01	127.98	128.65	1874369.0
2008-07-02 09:00:00	SPY	ETF	128.66	128.91	128.63	128.79	2585318.0
2008-07-02 09:30:00	SPY	ETF	128.79	129.08	128.64	128.94	21815644.0
2008-07-02 10:00:00	SPY	ETF	128.94	129.16	128.56	128.74	18215950.0
2008-07-02 10:30:00	SPY	ETF	128.74	129.13	128.5	128.87	23504631.0
2008-07-02 11:00:00	SPY	ETF	128.88	128.88	128.18	128.23	18101357.0
2008-07-02 11:30:00	SPY	ETF	128.23	128.69	127.72	127.83	25053198.0
2008-07-02 12:00:00	SPY	ETF	127.82	128.18	127.59	127.65	18067682.0
2008-07-02 12:30:00	SPY	ETF	127.65	127.99	127.49	127.86	11663148.0
2008-07-02 13:00:00	SPY	ETF	127.862	128.02	127.51	127.95	10484182.0
2008-07-02 13:30:00	SPY	ETF	127.94	128.4	127.79	128.3	17350142.0
2008-07-02 14:00:00	SPY	ETF	128.3	128.41	127.55	127.56	18337492.0
2008-07-02 14:30:00	SPY	ETF	127.56	128.3883	127.16	127.3	28571583.0
2008-07-02 15:00:00	SPY	ETF	127.29	127.37	126.86	126.86	24559754.0
2008-07-02 15:30:00	SPY	ETF	126.87	126.92	126.04	126.07	34331587.0
2008-07-02 16:00:00	SPY	ETF	126.06	126.25	125.96	126.19	3551456.0
2008-07-02 16:30:00	SPY	ETF	126.18	126.26	126.11	126.18	1542320.0
2008-07-02 17:00:00	SPY	ETF	126.18	126.19	126.03	126.08	455789.0
2008-07-02 17:30:00	SPY	ETF	126.05	126.09	125.98	126.01	46070.0
2008-07-02 18:00:00	SPY	ETF	126.01	126.18	126.01	126.16	3083702.0
2008-07-02 18:30:00	SPY	ETF	126.14	126.18	126.11	126.16	7530.0
2008-07-02 19:00:00	SPY	ETF	126.16	126.2	126.14	126.15	11430.0
2008-07-02 19:30:00	SPY	ETF	126.17	126.22	126.17	126.18	13302.0
2008-07-02 05:30:00	QQQ	ETF	46.0	46.03	46.0	46.03	600.0
2008-07-02 06:00:00	QQQ	ETF	46.08	46.12	46.08	46.11	25600.0
2008-07-02 06:30:00	QQQ	ETF	46.08	46.18	46.05	46.16	33000.0
2008-07-02 07:00:00	QQQ	ETF	46.15	46.24	46.13	46.23	90589.0
2008-07-02 07:30:00	QQQ	ETF	46.22	46.25	46.2	46.21	118164.0
2008-07-02 08:00:00	QQQ	ETF	46.2	46.21	45.81	46.12	1633891.0
2008-07-02 08:30:00	QQQ	ETF	46.12	46.15	46.02	46.02	1173307.0
2008-07-02 09:00:00	QQQ	ETF	46.02	46.12	45.94	45.94	2091916.0
2008-07-02 09:30:00	QQQ	ETF	45.95	46.13	45.77	45.85	18980336.0
2008-07-02 10:00:00	QQQ	ETF	45.85	46.0	45.68	45.71	13758009.0
2008-07-02 10:30:00	QQQ	ETF	45.71	45.89	45.59	45.8401	13778800.0
2008-07-02 11:00:00	QQQ	ETF	45.8401	45.8401	45.49	45.5115	11513454.0
2008-07-02 11:30:00	QQQ	ETF	45.52	45.57	45.23	45.32	15705107.0
2008-07-02 12:00:00	QQQ	ETF	45.31	45.5	45.19	45.27	14530264.0
2008-07-02 12:30:00	QQQ	ETF	45.26	45.33	45.13	45.27	9949247.0
2008-07-02 13:00:00	QQQ	ETF	45.27	45.45	45.15	45.39	9180611.0
2008-07-02 13:30:00	QQQ	ETF	45.39	45.62	45.34	45.57	11279125.0
2008-07-02 14:00:00	QQQ	ETF	45.5721	45.6	45.2	45.22	9500615.0
2008-07-02 14:30:00	QQQ	ETF	45.22	45.36	45.09	45.19	11482890.0
2008-07-02 15:00:00	QQQ	ETF	45.19	45.26	45.0	45.01	11381722.0

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

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