PREVIEW / etf_30min / 2008-06-18

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-06-18.parquet
  size:    170 KB
  rows:    5,921

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-06-18 04:00:00	SPY	ETF	135.44	135.44	135.44	135.44	100.0
2008-06-18 04:30:00	SPY	ETF	135.52	135.52	135.52	135.52	100.0
2008-06-18 05:00:00	SPY	ETF	135.66	135.66	135.66	135.66	100.0
2008-06-18 06:00:00	SPY	ETF	135.33	135.33	134.98	134.98	1600.0
2008-06-18 06:30:00	SPY	ETF	135.06	135.15	135.05	135.1	61200.0
2008-06-18 07:00:00	SPY	ETF	135.1	135.1	134.76	134.96	634520.0
2008-06-18 07:30:00	SPY	ETF	134.96	135.01	134.49	134.56	1473862.0
2008-06-18 08:00:00	SPY	ETF	134.57	135.74	134.35	134.67	4095387.0
2008-06-18 08:30:00	SPY	ETF	134.68	134.71	134.58	134.68	1270049.0
2008-06-18 09:00:00	SPY	ETF	134.69	134.73	134.56	134.71	1175656.0
2008-06-18 09:30:00	SPY	ETF	134.69	135.08	134.51	134.541	23986891.0
2008-06-18 10:00:00	SPY	ETF	134.55	134.79	134.43	134.5	13974188.0
2008-06-18 10:30:00	SPY	ETF	134.51	134.53	133.91	134.14	29421278.0
2008-06-18 11:00:00	SPY	ETF	134.14	134.53	134.08	134.34	17724367.0
2008-06-18 11:30:00	SPY	ETF	134.34	135.06	134.34	134.829	20258664.0
2008-06-18 12:00:00	SPY	ETF	134.82	135.5235	134.56	134.6	12349765.0
2008-06-18 12:30:00	SPY	ETF	134.6	134.78	134.26	134.41	11590406.0
2008-06-18 13:00:00	SPY	ETF	134.4	134.41	133.78	133.98	21490440.0
2008-06-18 13:30:00	SPY	ETF	133.98	134.27	133.86	134.14	14548997.0
2008-06-18 14:00:00	SPY	ETF	134.13	134.5	133.71	133.95	22082586.0
2008-06-18 14:30:00	SPY	ETF	133.94	134.52	133.82	134.41	14952899.0
2008-06-18 15:00:00	SPY	ETF	134.41	134.9	134.23	134.64	20014381.0
2008-06-18 15:30:00	SPY	ETF	134.64	134.7	134.08	134.33	26846508.0
2008-06-18 16:00:00	SPY	ETF	134.35	134.82	134.13	134.19	4814289.0
2008-06-18 16:30:00	SPY	ETF	134.16	134.25	134.09	134.09	858658.0
2008-06-18 17:00:00	SPY	ETF	134.09	134.09	134.01	134.05	172781.0
2008-06-18 17:30:00	SPY	ETF	134.03	134.03	134.02	134.03	19014.0
2008-06-18 18:00:00	SPY	ETF	134.04	134.07	134.01	134.03	26097.0
2008-06-18 18:30:00	SPY	ETF	135.5235	135.5235	133.99	134.05	1019182.0
2008-06-18 19:00:00	SPY	ETF	133.99	134.04	133.97	133.97	13425.0
2008-06-18 19:30:00	SPY	ETF	133.99	134.08	133.95	134.08	7643.0
2008-06-18 06:30:00	QQQ	ETF	48.47	48.5	48.47	48.49	1400.0
2008-06-18 07:00:00	QQQ	ETF	48.51	48.51	48.43	48.45	123262.0
2008-06-18 07:30:00	QQQ	ETF	48.47	48.5	48.26	48.31	250563.0
2008-06-18 08:00:00	QQQ	ETF	48.33	48.36	48.17	48.27	963622.0
2008-06-18 08:30:00	QQQ	ETF	48.28	48.31	48.27	48.3	661309.0
2008-06-18 09:00:00	QQQ	ETF	48.31	48.34	48.08	48.26	2607526.0
2008-06-18 09:30:00	QQQ	ETF	48.26	48.37	48.0	48.12	17464261.0
2008-06-18 10:00:00	QQQ	ETF	48.12	48.24	48.07	48.15	9335079.0
2008-06-18 10:30:00	QQQ	ETF	48.14	48.19	47.83	47.9	19614128.0
2008-06-18 11:00:00	QQQ	ETF	47.9	48.0912	47.87	48.03	11844069.0
2008-06-18 11:30:00	QQQ	ETF	48.04	48.45	48.03	48.37	11296378.0
2008-06-18 12:00:00	QQQ	ETF	48.37	48.381	48.14	48.15	8188881.0
2008-06-18 12:30:00	QQQ	ETF	48.15	48.2581	48.04	48.11	6127461.0
2008-06-18 13:00:00	QQQ	ETF	48.11	48.11	47.89	47.94	8910360.0
2008-06-18 13:30:00	QQQ	ETF	47.94	48.09	47.88	48.04	8205883.0
2008-06-18 14:00:00	QQQ	ETF	48.04	48.15	47.87	47.91	9407552.0
2008-06-18 14:30:00	QQQ	ETF	47.91	48.16	47.88	48.09	8694693.0
2008-06-18 15:00:00	QQQ	ETF	48.09	48.33	48.02	48.2311	12232501.0
2008-06-18 15:30:00	QQQ	ETF	48.23	48.26	48.0	48.01	15991053.0

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

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