PREVIEW / etf_30min / 2008-03-18

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-03-18.parquet
  size:    162 KB
  rows:    5,778

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-03-18 04:00:00	SPY	ETF	129.26	129.29	129.19	129.19	6700.0
2008-03-18 04:30:00	SPY	ETF	129.3	129.31	129.12	129.26	3400.0
2008-03-18 05:00:00	SPY	ETF	129.28	129.59	129.28	129.59	1200.0
2008-03-18 05:30:00	SPY	ETF	129.38	129.54	129.38	129.54	3300.0
2008-03-18 06:00:00	SPY	ETF	129.5	129.51	129.35	129.44	22100.0
2008-03-18 06:30:00	SPY	ETF	129.5	129.78	129.5	129.75	180700.0
2008-03-18 07:00:00	SPY	ETF	129.81	129.91	129.7	129.8	325800.0
2008-03-18 07:30:00	SPY	ETF	129.8	130.14	129.63	130.04	1000700.0
2008-03-18 08:00:00	SPY	ETF	130.03	130.49	129.35	130.21	8064100.0
2008-03-18 08:30:00	SPY	ETF	130.2	130.4	129.77	130.37	2905800.0
2008-03-18 09:00:00	SPY	ETF	130.37	130.72	128.37	130.61	4115200.0
2008-03-18 09:30:00	SPY	ETF	130.62	130.95	130.42	130.79	22990612.0
2008-03-18 10:00:00	SPY	ETF	130.79	131.07	130.62	130.79	15081658.0
2008-03-18 10:30:00	SPY	ETF	130.79	131.31	130.63	131.26	16789207.0
2008-03-18 11:00:00	SPY	ETF	131.26	131.52	131.19	131.46	11850063.0
2008-03-18 11:30:00	SPY	ETF	131.46	131.68	131.33	131.36	10137188.0
2008-03-18 12:00:00	SPY	ETF	131.36	131.51	131.21	131.49	10365736.0
2008-03-18 12:30:00	SPY	ETF	131.49	131.83	131.47	131.71	10094952.0
2008-03-18 13:00:00	SPY	ETF	131.71	132.05	131.6	131.88	12710895.0
2008-03-18 13:30:00	SPY	ETF	131.89	132.06	131.7283	131.9	9754352.0
2008-03-18 14:00:00	SPY	ETF	131.9	132.0	130.44	130.87	54780920.0
2008-03-18 14:30:00	SPY	ETF	130.86	132.62	129.98	132.489	59803026.0
2008-03-18 15:00:00	SPY	ETF	132.5	132.71	131.98	132.4	29962215.0
2008-03-18 15:30:00	SPY	ETF	132.4	133.38	130.67	133.32	29590261.0
2008-03-18 16:00:00	SPY	ETF	133.32	133.7	133.1	133.58	11164846.0
2008-03-18 16:30:00	SPY	ETF	133.58	133.65	133.5064	133.6	3307600.0
2008-03-18 17:00:00	SPY	ETF	133.6	133.67	133.251	133.6	5501500.0
2008-03-18 17:30:00	SPY	ETF	133.6	133.7	133.6	133.62	7500.0
2008-03-18 18:00:00	SPY	ETF	133.62	133.63	133.5	133.58	92300.0
2008-03-18 18:30:00	SPY	ETF	133.6	133.62	133.5	133.52	52400.0
2008-03-18 19:00:00	SPY	ETF	133.5	133.57	133.48	133.53	6100.0
2008-03-18 19:30:00	SPY	ETF	133.56	133.59	133.49	133.58	23700.0
2008-03-18 04:00:00	QQQ	ETF	41.93	41.93	41.93	41.93	100.0
2008-03-18 04:30:00	QQQ	ETF	41.98	42.03	41.98	42.03	700.0
2008-03-18 05:00:00	QQQ	ETF	41.96	41.96	41.96	41.96	100.0
2008-03-18 07:00:00	QQQ	ETF	42.03	42.09	42.03	42.08	93183.0
2008-03-18 07:30:00	QQQ	ETF	42.07	42.07	41.99	42.0	280907.0
2008-03-18 08:00:00	QQQ	ETF	42.0	42.13	41.99	42.08	1699656.0
2008-03-18 08:30:00	QQQ	ETF	42.09	42.18	42.0	42.17	1594016.0
2008-03-18 09:00:00	QQQ	ETF	42.16	42.28	42.14	42.23	2636818.0
2008-03-18 09:30:00	QQQ	ETF	42.24	42.47	42.23	42.2901	21916593.0
2008-03-18 10:00:00	QQQ	ETF	42.3	42.4	42.26	42.3	5309787.0
2008-03-18 10:30:00	QQQ	ETF	42.3	42.42	42.25	42.38	6325139.0
2008-03-18 11:00:00	QQQ	ETF	42.38	42.51	42.35	42.48	7279685.0
2008-03-18 11:30:00	QQQ	ETF	42.48	42.56	42.42	42.43	7167465.0
2008-03-18 12:00:00	QQQ	ETF	42.44	42.5	42.39	42.48	4151543.0
2008-03-18 12:30:00	QQQ	ETF	42.48	42.66	42.47	42.6207	8553637.0
2008-03-18 13:00:00	QQQ	ETF	42.62	42.78	42.6	42.67	7326600.0
2008-03-18 13:30:00	QQQ	ETF	42.68	42.77	42.63	42.7	4584148.0
2008-03-18 14:00:00	QQQ	ETF	42.71	42.74	42.28	42.38	38221652.0

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

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