PREVIEW / etf_30min / 2008-08-12

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-08-12.parquet
  size:    168 KB
  rows:    5,939

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-08-12 04:30:00	SPY	ETF	130.19	130.26	130.01	130.26	800.0
2008-08-12 05:00:00	SPY	ETF	130.57	130.57	130.57	130.57	1000.0
2008-08-12 06:00:00	SPY	ETF	130.34	130.34	130.32	130.32	2000.0
2008-08-12 06:30:00	SPY	ETF	130.36	130.6	130.34	130.6	36200.0
2008-08-12 07:00:00	SPY	ETF	130.61	130.84	130.6	130.84	194400.0
2008-08-12 07:30:00	SPY	ETF	130.81	130.91	130.53	130.6	273510.0
2008-08-12 08:00:00	SPY	ETF	130.6	130.65	130.41	130.46	826422.0
2008-08-12 08:30:00	SPY	ETF	130.48	130.62	130.27	130.45	2003285.0
2008-08-12 09:00:00	SPY	ETF	130.46	130.71	130.09	130.27	2106680.0
2008-08-12 09:30:00	SPY	ETF	130.2801	130.355	129.83	130.08	24687225.0
2008-08-12 10:00:00	SPY	ETF	130.08	130.34	129.74	129.75	19296419.0
2008-08-12 10:30:00	SPY	ETF	129.75	129.93	129.59	129.83	15520220.0
2008-08-12 11:00:00	SPY	ETF	129.83	130.31	129.73	130.28	16165438.0
2008-08-12 11:30:00	SPY	ETF	130.28	130.335	129.99	130.039	10932796.0
2008-08-12 12:00:00	SPY	ETF	130.03	130.11	129.93	130.069	6991057.0
2008-08-12 12:30:00	SPY	ETF	130.06	130.7028	129.87	130.14	12954600.0
2008-08-12 13:00:00	SPY	ETF	130.14	130.22	129.79	129.82	7737989.0
2008-08-12 13:30:00	SPY	ETF	129.82	130.05	129.62	129.73	11505956.0
2008-08-12 14:00:00	SPY	ETF	129.73	130.07	129.61	129.98	13062566.0
2008-08-12 14:30:00	SPY	ETF	129.99	130.0	129.5	129.52	7174321.0
2008-08-12 15:00:00	SPY	ETF	129.52	129.56	129.0	129.16	28410432.0
2008-08-12 15:30:00	SPY	ETF	129.17	129.27	128.73	129.25	24573109.0
2008-08-12 16:00:00	SPY	ETF	129.261	130.0	129.1	129.28	5243345.0
2008-08-12 16:30:00	SPY	ETF	129.3	129.43	129.26	129.43	375488.0
2008-08-12 17:00:00	SPY	ETF	129.4	129.49	129.35	129.49	146718.0
2008-08-12 17:30:00	SPY	ETF	129.43	129.53	129.35	129.5	48297.0
2008-08-12 18:00:00	SPY	ETF	129.46	129.49	129.39	129.39	193355.0
2008-08-12 18:30:00	SPY	ETF	129.4	129.41	129.36	129.37	9644.0
2008-08-12 19:30:00	SPY	ETF	129.39	129.4	129.3	129.3	16723.0
2008-08-12 04:00:00	QQQ	ETF	47.58	47.58	47.56	47.56	300.0
2008-08-12 04:30:00	QQQ	ETF	47.54	47.54	47.52	47.52	400.0
2008-08-12 05:00:00	QQQ	ETF	47.63	47.66	47.63	47.66	1500.0
2008-08-12 06:30:00	QQQ	ETF	47.7	47.78	47.7	47.78	600.0
2008-08-12 07:00:00	QQQ	ETF	47.79	47.89	47.79	47.89	46200.0
2008-08-12 07:30:00	QQQ	ETF	47.89	47.93	47.8	47.82	112103.0
2008-08-12 08:00:00	QQQ	ETF	47.83	47.85	47.77	47.8	526708.0
2008-08-12 08:30:00	QQQ	ETF	47.81	47.88	47.65	47.75	1004074.0
2008-08-12 09:00:00	QQQ	ETF	47.75	47.76	47.62	47.75	1595564.0
2008-08-12 09:30:00	QQQ	ETF	47.75	47.82	47.51	47.71	18482374.0
2008-08-12 10:00:00	QQQ	ETF	47.72	48.07	47.68	47.72	20320700.0
2008-08-12 10:30:00	QQQ	ETF	47.73	47.88	47.64	47.83	10799432.0
2008-08-12 11:00:00	QQQ	ETF	47.83	48.12	47.79	48.11	11497049.0
2008-08-12 11:30:00	QQQ	ETF	48.11	48.16	47.92	47.93	10449282.0
2008-08-12 12:00:00	QQQ	ETF	47.93	47.98	47.89	47.96	2895553.0
2008-08-12 12:30:00	QQQ	ETF	47.96	48.0	47.87	48.0	4106151.0
2008-08-12 13:00:00	QQQ	ETF	47.99	48.03	47.87	47.8801	5108167.0
2008-08-12 13:30:00	QQQ	ETF	47.89	47.99	47.78	47.82	7000299.0
2008-08-12 14:00:00	QQQ	ETF	47.81	48.04	47.81	48.0	4933668.0
2008-08-12 14:30:00	QQQ	ETF	48.0	48.01	47.82	47.83	2690664.0
2008-08-12 15:00:00	QQQ	ETF	47.83	47.86	47.6	47.68	16726474.0

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

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