PREVIEW / etf_30min / 2008-11-21

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-11-21.parquet
  size:    195 KB
  rows:    7,044

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-11-21 04:00:00	SPY	ETF	78.52	78.67	78.52	78.67	4405.0
2008-11-21 04:30:00	SPY	ETF	78.5	78.55	78.32	78.41	22478.0
2008-11-21 05:00:00	SPY	ETF	78.75	78.93	78.33	78.38	9711.0
2008-11-21 05:30:00	SPY	ETF	78.41	78.53	77.75	77.8	63199.0
2008-11-21 06:00:00	SPY	ETF	78.06	78.06	77.48	77.48	220880.0
2008-11-21 06:30:00	SPY	ETF	77.6	77.79	77.31	77.58	186190.0
2008-11-21 07:00:00	SPY	ETF	77.52	77.7	77.15	77.6	1074709.0
2008-11-21 07:30:00	SPY	ETF	77.55	77.62	77.04	77.06	1582480.0
2008-11-21 08:00:00	SPY	ETF	77.44	78.5	76.4	77.33	4049414.0
2008-11-21 08:30:00	SPY	ETF	77.33	77.63	76.96	77.42	2298145.0
2008-11-21 09:00:00	SPY	ETF	77.42	77.57	77.03	77.45	4067868.0
2008-11-21 09:30:00	SPY	ETF	77.46	77.75	76.06	76.46	75410698.0
2008-11-21 10:00:00	SPY	ETF	76.45	76.93	75.63	75.68	54081600.0
2008-11-21 10:30:00	SPY	ETF	75.68	76.64	75.0	75.16	50621126.0
2008-11-21 11:00:00	SPY	ETF	75.16	77.09	74.34	75.73	43632532.0
2008-11-21 11:30:00	SPY	ETF	75.73	76.67	75.5318	75.72	30441914.0
2008-11-21 12:00:00	SPY	ETF	75.72	76.49	75.37	76.46	26906533.0
2008-11-21 12:30:00	SPY	ETF	76.46	77.25	76.0	76.51	30656832.0
2008-11-21 13:00:00	SPY	ETF	76.51	77.1	75.58	75.84	21200942.0
2008-11-21 13:30:00	SPY	ETF	75.84	76.36	74.92	74.95	25542173.0
2008-11-21 14:00:00	SPY	ETF	74.95	76.5	74.77	75.68	38783995.0
2008-11-21 14:30:00	SPY	ETF	75.68	76.29	74.58	75.21	49482781.0
2008-11-21 15:00:00	SPY	ETF	75.21	78.22	75.14	77.89	87105295.0
2008-11-21 15:30:00	SPY	ETF	77.88	80.9	75.06	80.36	126755371.0
2008-11-21 16:00:00	SPY	ETF	80.29	80.6	75.7995	79.67	23894839.0
2008-11-21 16:30:00	SPY	ETF	79.66	80.34	75.45	79.73	12878132.0
2008-11-21 17:00:00	SPY	ETF	75.6037	80.4	74.79	75.7875	4416558.0
2008-11-21 17:30:00	SPY	ETF	75.765	79.79	74.8725	79.75	261303.0
2008-11-21 18:00:00	SPY	ETF	79.75	80.3	78.0	79.61	270063.0
2008-11-21 18:30:00	SPY	ETF	79.53	79.93	79.53	79.83	63936.0
2008-11-21 19:00:00	SPY	ETF	79.87	79.9	79.7	79.78	37532.0
2008-11-21 19:30:00	SPY	ETF	79.79	79.8	79.4	79.45	86472.0
2008-11-21 04:00:00	QQQ	ETF	26.75	26.75	26.64	26.73	15882.0
2008-11-21 04:30:00	QQQ	ETF	26.61	26.61	26.54	26.57	7200.0
2008-11-21 05:00:00	QQQ	ETF	26.55	26.68	26.55	26.68	4200.0
2008-11-21 05:30:00	QQQ	ETF	26.61	26.61	26.48	26.48	2500.0
2008-11-21 06:00:00	QQQ	ETF	26.5	26.54	26.47	26.47	2310.0
2008-11-21 06:30:00	QQQ	ETF	26.46	26.46	26.41	26.41	4000.0
2008-11-21 07:00:00	QQQ	ETF	26.43	26.43	26.2	26.26	316190.0
2008-11-21 07:30:00	QQQ	ETF	26.22	26.25	25.97	25.97	421158.0
2008-11-21 08:00:00	QQQ	ETF	25.98	26.65	25.9	26.1	3245745.0
2008-11-21 08:30:00	QQQ	ETF	26.1	26.15	26.0	26.07	1613345.0
2008-11-21 09:00:00	QQQ	ETF	26.09	26.14	25.94	25.96	1274886.0
2008-11-21 09:30:00	QQQ	ETF	25.97	26.24	25.79	25.99	33527117.0
2008-11-21 10:00:00	QQQ	ETF	25.98	26.1	25.65	25.6796	24349687.0
2008-11-21 10:30:00	QQQ	ETF	25.67	25.82	25.35	25.4	19041130.0
2008-11-21 11:00:00	QQQ	ETF	25.41	25.7495	25.21	25.7	13312894.0
2008-11-21 11:30:00	QQQ	ETF	25.69	25.96	25.64	25.69	11518212.0
2008-11-21 12:00:00	QQQ	ETF	25.69	25.92	25.58	25.818	10216065.0
2008-11-21 12:30:00	QQQ	ETF	25.82	26.06	25.74	25.77	11847628.0

> showing 50 of 7,044 rows — these rows as CSV

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