PREVIEW / etf_30min / 2008-06-27

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-06-27.parquet
  size:    172 KB
  rows:    5,959

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-27 04:00:00	SPY	ETF	128.37	128.5	128.3	128.3	6500.0
2008-06-27 04:30:00	SPY	ETF	128.44	128.66	128.44	128.66	1600.0
2008-06-27 05:00:00	SPY	ETF	128.52	128.52	128.15	128.15	800.0
2008-06-27 05:30:00	SPY	ETF	128.17	128.45	128.17	128.45	24700.0
2008-06-27 06:00:00	SPY	ETF	128.38	128.56	128.35	128.43	45300.0
2008-06-27 06:30:00	SPY	ETF	128.48	128.49	128.33	128.33	108600.0
2008-06-27 07:00:00	SPY	ETF	128.31	128.31	128.0	128.05	389371.0
2008-06-27 07:30:00	SPY	ETF	127.97	128.05	127.58	127.82	927441.0
2008-06-27 08:00:00	SPY	ETF	127.84	128.28	127.73	127.79	2010175.0
2008-06-27 08:30:00	SPY	ETF	127.91	128.46	127.67	128.38	6439565.0
2008-06-27 09:00:00	SPY	ETF	128.38	128.53	128.08	128.27	2036971.0
2008-06-27 09:30:00	SPY	ETF	128.28	128.58	127.79	128.44	30505733.0
2008-06-27 10:00:00	SPY	ETF	128.455	128.86	128.3	128.41	26023337.0
2008-06-27 10:30:00	SPY	ETF	128.4	128.8	127.75	127.91	24219467.0
2008-06-27 11:00:00	SPY	ETF	127.9197	128.16	127.66	128.09	18918497.0
2008-06-27 11:30:00	SPY	ETF	128.08	128.25	127.9	128.06	14286516.0
2008-06-27 12:00:00	SPY	ETF	128.06	128.43	128.0	128.25	10091517.0
2008-06-27 12:30:00	SPY	ETF	128.25	128.3	127.74	127.89	11653918.0
2008-06-27 13:00:00	SPY	ETF	127.88	127.93	127.26	127.37	21434422.0
2008-06-27 13:30:00	SPY	ETF	127.375	127.49	127.035	127.36	22071485.0
2008-06-27 14:00:00	SPY	ETF	127.36	128.18	127.2	128.01	25059843.0
2008-06-27 14:30:00	SPY	ETF	128.01	128.27	127.66	128.14	19172322.0
2008-06-27 15:00:00	SPY	ETF	128.13	128.19	127.56	127.64	15959554.0
2008-06-27 15:30:00	SPY	ETF	127.64	128.24	127.5	127.8	31335420.0
2008-06-27 16:00:00	SPY	ETF	127.811	127.96	127.45	127.62	8926995.0
2008-06-27 16:30:00	SPY	ETF	127.58	127.79	127.56	127.78	1616077.0
2008-06-27 17:00:00	SPY	ETF	127.77	127.88	127.73	127.76	198276.0
2008-06-27 17:30:00	SPY	ETF	127.8	127.87	127.76	127.76	29755.0
2008-06-27 18:00:00	SPY	ETF	127.73	127.75	127.7	127.71	7900.0
2008-06-27 18:30:00	SPY	ETF	127.79	127.79	127.74	127.74	3300.0
2008-06-27 19:00:00	SPY	ETF	127.79	127.82	127.75	127.82	3415.0
2008-06-27 19:30:00	SPY	ETF	127.81	127.91	127.79	127.89	6857.0
2008-06-27 04:00:00	QQQ	ETF	45.8	45.82	45.75	45.78	3200.0
2008-06-27 04:30:00	QQQ	ETF	45.8	45.8	45.8	45.8	900.0
2008-06-27 05:00:00	QQQ	ETF	45.8	45.8	45.7	45.7	2000.0
2008-06-27 05:30:00	QQQ	ETF	45.69	45.86	45.69	45.78	100997.0
2008-06-27 06:00:00	QQQ	ETF	45.73	45.81	45.73	45.75	1400.0
2008-06-27 06:30:00	QQQ	ETF	45.79	45.79	45.76	45.76	3000.0
2008-06-27 07:00:00	QQQ	ETF	45.74	45.74	45.6	45.65	123534.0
2008-06-27 07:30:00	QQQ	ETF	45.65	45.66	45.4	45.54	644715.0
2008-06-27 08:00:00	QQQ	ETF	45.55	45.72	45.47	45.49	1055047.0
2008-06-27 08:30:00	QQQ	ETF	45.5	45.67	45.47	45.65	2294544.0
2008-06-27 09:00:00	QQQ	ETF	45.64	45.71	45.58	45.59	1616177.0
2008-06-27 09:30:00	QQQ	ETF	45.59	45.73	45.28	45.65	18541559.0
2008-06-27 10:00:00	QQQ	ETF	45.65	45.9	45.46	45.57	16378885.0
2008-06-27 10:30:00	QQQ	ETF	45.56	45.79	45.28	45.4	15444881.0
2008-06-27 11:00:00	QQQ	ETF	45.4	45.48	45.26	45.46	7779704.0
2008-06-27 11:30:00	QQQ	ETF	45.45	45.55	45.39	45.48	4976365.0
2008-06-27 12:00:00	QQQ	ETF	45.48	45.67	45.48	45.63	5235831.0
2008-06-27 12:30:00	QQQ	ETF	45.63	45.65	45.33	45.41	8983684.0

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

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