PREVIEW / etf_30min / 2010-10-04

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-10-04.parquet
  size:    257 KB
  rows:    8,677

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
2010-10-04 04:00:00	SPY	ETF	114.49	114.49	114.13	114.13	1832.0
2010-10-04 04:30:00	SPY	ETF	114.09	114.09	113.96	114.09	700.0
2010-10-04 05:00:00	SPY	ETF	114.09	114.09	113.94	113.94	5938.0
2010-10-04 05:30:00	SPY	ETF	113.94	114.08	113.93	113.93	28931.0
2010-10-04 06:00:00	SPY	ETF	114.09	114.11	114.04	114.1	16200.0
2010-10-04 06:30:00	SPY	ETF	114.14	114.24	114.04	114.1	17100.0
2010-10-04 07:00:00	SPY	ETF	114.16	114.43	114.1	114.34	81706.0
2010-10-04 07:30:00	SPY	ETF	114.39	114.43	114.34	114.42	124512.0
2010-10-04 08:00:00	SPY	ETF	114.42	114.46	114.16	114.18	299511.0
2010-10-04 08:30:00	SPY	ETF	114.17	114.45	114.0	114.28	337932.0
2010-10-04 09:00:00	SPY	ETF	114.29	114.45	114.27	114.36	873806.0
2010-10-04 09:30:00	SPY	ETF	114.37	114.85	114.36	114.46	27941052.0
2010-10-04 10:00:00	SPY	ETF	114.46	114.7	114.19	114.5	13712072.0
2010-10-04 10:30:00	SPY	ETF	114.5	114.59	114.11	114.23	11009198.0
2010-10-04 11:00:00	SPY	ETF	114.23	114.23	113.63	113.748	18318844.0
2010-10-04 11:30:00	SPY	ETF	113.74	113.87	113.42	113.44	8352952.0
2010-10-04 12:00:00	SPY	ETF	113.44	113.46	113.18	113.39	11887779.0
2010-10-04 12:30:00	SPY	ETF	113.4	113.52	113.32	113.47	5683642.0
2010-10-04 13:00:00	SPY	ETF	113.46	113.62	113.43	113.54	7203897.0
2010-10-04 13:30:00	SPY	ETF	113.53	113.58	113.35	113.54	5440717.0
2010-10-04 14:00:00	SPY	ETF	113.55	113.59	113.24	113.36	5904128.0
2010-10-04 14:30:00	SPY	ETF	113.36	113.61	113.31	113.45	8180237.0
2010-10-04 15:00:00	SPY	ETF	113.45	113.78	113.4	113.68	13197525.0
2010-10-04 15:30:00	SPY	ETF	113.68	113.76	113.51	113.74	20090715.0
2010-10-04 16:00:00	SPY	ETF	113.74	114.17	113.74	113.94	4360814.0
2010-10-04 16:30:00	SPY	ETF	113.96	114.0	113.93	113.97	1476030.0
2010-10-04 17:00:00	SPY	ETF	113.98	114.0	113.92	113.93	40270.0
2010-10-04 17:30:00	SPY	ETF	113.93	113.98	113.93	113.94	10993.0
2010-10-04 18:00:00	SPY	ETF	113.94	113.96	113.75	113.93	49048.0
2010-10-04 18:30:00	SPY	ETF	113.95	113.96	113.93	113.96	30204.0
2010-10-04 19:00:00	SPY	ETF	113.93	113.95	113.88	113.9	30881.0
2010-10-04 19:30:00	SPY	ETF	113.88	113.95	113.85	113.91	63472.0
2010-10-04 04:00:00	QQQ	ETF	48.95	48.95	48.95	48.95	400.0
2010-10-04 04:30:00	QQQ	ETF	48.75	48.75	48.68	48.68	2100.0
2010-10-04 05:00:00	QQQ	ETF	48.72	48.73	48.72	48.73	5400.0
2010-10-04 05:30:00	QQQ	ETF	48.72	48.72	48.72	48.72	100.0
2010-10-04 06:00:00	QQQ	ETF	48.81	48.81	48.81	48.81	500.0
2010-10-04 06:30:00	QQQ	ETF	48.77	48.77	48.75	48.75	5000.0
2010-10-04 07:00:00	QQQ	ETF	48.78	48.91	48.78	48.9	28945.0
2010-10-04 07:30:00	QQQ	ETF	48.89	48.9	48.85	48.88	34710.0
2010-10-04 08:00:00	QQQ	ETF	48.88	48.91	48.79	48.79	106801.0
2010-10-04 08:30:00	QQQ	ETF	48.81	48.84	48.78	48.83	300136.0
2010-10-04 09:00:00	QQQ	ETF	48.83	49.01	48.8	48.87	499092.0
2010-10-04 09:30:00	QQQ	ETF	48.86	49.05	48.78	48.81	11152728.0
2010-10-04 10:00:00	QQQ	ETF	48.82	48.96	48.6901	48.898	7091515.0
2010-10-04 10:30:00	QQQ	ETF	48.895	48.93	48.72	48.7701	3397238.0
2010-10-04 11:00:00	QQQ	ETF	48.77	48.77	48.3	48.3715	6507813.0
2010-10-04 11:30:00	QQQ	ETF	48.37	48.46	48.29	48.3	4385595.0
2010-10-04 12:00:00	QQQ	ETF	48.29	48.34	48.2	48.28	4089324.0
2010-10-04 12:30:00	QQQ	ETF	48.28	48.35	48.24	48.325	2944365.0

> showing 50 of 8,677 rows — these rows as CSV

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