PREVIEW / etf_30min / 2008-09-18

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-09-18.parquet
  size:    195 KB
  rows:    6,783

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-09-18 04:00:00	SPY	ETF	117.69	118.18	117.69	118.18	5000.0
2008-09-18 04:30:00	SPY	ETF	118.2	118.3	117.83	117.91	6100.0
2008-09-18 05:00:00	SPY	ETF	117.81	118.1	117.81	118.1	3500.0
2008-09-18 05:30:00	SPY	ETF	118.15	118.15	117.91	117.91	11900.0
2008-09-18 06:00:00	SPY	ETF	117.98	118.33	117.7	118.21	127350.0
2008-09-18 06:30:00	SPY	ETF	118.18	118.5	117.78	118.5	233530.0
2008-09-18 07:00:00	SPY	ETF	118.45	118.56	117.98	118.21	1138451.0
2008-09-18 07:30:00	SPY	ETF	118.16	118.25	117.82	117.96	1408289.0
2008-09-18 08:00:00	SPY	ETF	117.96	118.31	116.99	117.51	8491260.0
2008-09-18 08:30:00	SPY	ETF	117.5	118.15	117.25	117.44	4374672.0
2008-09-18 09:00:00	SPY	ETF	117.44	118.2	117.07	118.06	5194214.0
2008-09-18 09:30:00	SPY	ETF	118.05	118.68	117.35	118.54	60306611.0
2008-09-18 10:00:00	SPY	ETF	118.5	119.0	117.78	118.31	33234649.0
2008-09-18 10:30:00	SPY	ETF	118.31	118.38	116.9	117.02	28160179.0
2008-09-18 11:00:00	SPY	ETF	117.01	117.23	115.99	116.43	39652229.0
2008-09-18 11:30:00	SPY	ETF	116.44	117.01	115.42	116.3301	36097786.0
2008-09-18 12:00:00	SPY	ETF	116.338	117.6	115.45	115.88	38857946.0
2008-09-18 12:30:00	SPY	ETF	115.87	116.0	113.81	113.85	60401301.0
2008-09-18 13:00:00	SPY	ETF	113.86	116.5	113.8	116.13	64320204.0
2008-09-18 13:30:00	SPY	ETF	116.12	117.99	116.11	117.35	62665289.0
2008-09-18 14:00:00	SPY	ETF	117.34	117.5	116.04	116.45	42632785.0
2008-09-18 14:30:00	SPY	ETF	116.45	117.56	115.89	117.35	40081894.0
2008-09-18 15:00:00	SPY	ETF	117.35	121.0	117.19	120.26	92972518.0
2008-09-18 15:30:00	SPY	ETF	120.26	121.79	120.08	120.59	87697066.0
2008-09-18 16:00:00	SPY	ETF	120.55	121.12	117.5669	120.21	20341345.0
2008-09-18 16:30:00	SPY	ETF	120.22	120.61	116.1752	120.39	3965538.0
2008-09-18 17:00:00	SPY	ETF	120.39	120.58	120.35	120.55	10304224.0
2008-09-18 17:30:00	SPY	ETF	116.18	120.85	116.18	120.79	3562408.0
2008-09-18 18:00:00	SPY	ETF	120.76	121.12	120.542	121.02	934275.0
2008-09-18 18:30:00	SPY	ETF	121.05	122.07	120.54	121.87	356659.0
2008-09-18 19:00:00	SPY	ETF	121.85	121.97	121.62	121.65	16859400.0
2008-09-18 19:30:00	SPY	ETF	121.64	123.19	121.57	122.9	696498.0
2008-09-18 04:00:00	QQQ	ETF	40.65	40.78	40.62	40.78	1500.0
2008-09-18 04:30:00	QQQ	ETF	40.8	40.81	40.78	40.79	26300.0
2008-09-18 05:00:00	QQQ	ETF	40.77	40.81	40.77	40.81	600.0
2008-09-18 06:00:00	QQQ	ETF	40.68	40.82	40.64	40.82	27400.0
2008-09-18 06:30:00	QQQ	ETF	40.79	40.96	40.67	40.95	335000.0
2008-09-18 07:00:00	QQQ	ETF	40.92	40.93	40.77	40.86	61302.0
2008-09-18 07:30:00	QQQ	ETF	40.82	40.88	40.78	40.87	58721.0
2008-09-18 08:00:00	QQQ	ETF	40.87	40.87	40.63	40.69	2006837.0
2008-09-18 08:30:00	QQQ	ETF	40.67	40.93	40.63	40.79	1876809.0
2008-09-18 09:00:00	QQQ	ETF	40.78	41.21	40.54	41.11	4630806.0
2008-09-18 09:30:00	QQQ	ETF	41.12	41.25	40.46	40.89	48517019.0
2008-09-18 10:00:00	QQQ	ETF	40.89	41.21	40.69	40.8	26871762.0
2008-09-18 10:30:00	QQQ	ETF	40.8	40.84	40.26	40.27	17005454.0
2008-09-18 11:00:00	QQQ	ETF	40.27	40.42	40.0	40.13	22525846.0
2008-09-18 11:30:00	QQQ	ETF	40.135	40.29	39.79	40.1	20877689.0
2008-09-18 12:00:00	QQQ	ETF	40.09	40.21	39.84	39.97	17897145.0
2008-09-18 12:30:00	QQQ	ETF	39.97	39.98	39.51	39.57	25610286.0
2008-09-18 13:00:00	QQQ	ETF	39.57	40.3	39.5	40.02	30302818.0

> showing 50 of 6,783 rows — these rows as CSV

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