PREVIEW / etf_30min / 2010-11-01

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-11-01.parquet
  size:    263 KB
  rows:    8,759

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-11-01 04:00:00	SPY	ETF	118.8	119.31	118.8	119.24	26488.0
2010-11-01 04:30:00	SPY	ETF	119.3	119.41	119.3	119.41	1900.0
2010-11-01 05:00:00	SPY	ETF	119.41	119.41	119.38	119.38	330.0
2010-11-01 05:30:00	SPY	ETF	119.38	119.38	119.15	119.15	1200.0
2010-11-01 06:00:00	SPY	ETF	119.05	119.05	118.96	118.96	17400.0
2010-11-01 06:30:00	SPY	ETF	119.03	119.15	118.94	119.15	114050.0
2010-11-01 07:00:00	SPY	ETF	119.11	119.14	119.04	119.04	62361.0
2010-11-01 07:30:00	SPY	ETF	119.04	119.17	118.96	118.98	336473.0
2010-11-01 08:00:00	SPY	ETF	118.96	119.37	118.49	118.98	394569.0
2010-11-01 08:30:00	SPY	ETF	118.99	119.05	118.53	119.02	782570.0
2010-11-01 09:00:00	SPY	ETF	119.03	119.15	118.49	119.07	769308.0
2010-11-01 09:30:00	SPY	ETF	119.07	119.42	119.04	119.28	17287656.0
2010-11-01 10:00:00	SPY	ETF	119.29	119.75	119.2875	119.52	20981565.0
2010-11-01 10:30:00	SPY	ETF	119.52	119.57	119.32	119.37	10573407.0
2010-11-01 11:00:00	SPY	ETF	119.37	119.38	118.93	119.01	12547558.0
2010-11-01 11:30:00	SPY	ETF	119.0001	119.05	118.76	119.05	11372951.0
2010-11-01 12:00:00	SPY	ETF	119.04	119.11	118.89	119.05	8575716.0
2010-11-01 12:30:00	SPY	ETF	119.05	119.07	118.7497	118.83	5509053.0
2010-11-01 13:00:00	SPY	ETF	118.82	118.97	118.69	118.83	6801630.0
2010-11-01 13:30:00	SPY	ETF	118.83	119.06	118.8	118.91	4425803.0
2010-11-01 14:00:00	SPY	ETF	118.91	118.95	118.73	118.74	8487347.0
2010-11-01 14:30:00	SPY	ETF	118.73	118.77	118.36	118.46	11308054.0
2010-11-01 15:00:00	SPY	ETF	118.47	118.48	117.85	118.17	19800935.0
2010-11-01 15:30:00	SPY	ETF	118.175	118.58	118.13	118.55	18190995.0
2010-11-01 16:00:00	SPY	ETF	118.55	119.705	118.46	118.73	9302170.0
2010-11-01 16:30:00	SPY	ETF	118.74	118.75	118.65	118.7	1456266.0
2010-11-01 17:00:00	SPY	ETF	118.71	118.75	118.4601	118.65	1231645.0
2010-11-01 17:30:00	SPY	ETF	118.68	118.72	118.66	118.7	1145078.0
2010-11-01 18:00:00	SPY	ETF	118.67	118.68	118.53	118.57	152124.0
2010-11-01 18:30:00	SPY	ETF	118.58	118.63	118.58	118.6	16054.0
2010-11-01 19:00:00	SPY	ETF	118.63	118.69	118.6	118.69	32282.0
2010-11-01 19:30:00	SPY	ETF	118.66	118.77	118.66	118.74	32413.0
2010-11-01 04:00:00	QQQ	ETF	52.46	52.49	52.46	52.49	20100.0
2010-11-01 04:30:00	QQQ	ETF	52.44	52.47	52.44	52.47	2100.0
2010-11-01 05:00:00	QQQ	ETF	52.46	52.46	52.46	52.46	100.0
2010-11-01 05:30:00	QQQ	ETF	52.5	52.5	52.5	52.5	300.0
2010-11-01 06:00:00	QQQ	ETF	52.36	52.38	52.34	52.34	14700.0
2010-11-01 06:30:00	QQQ	ETF	52.4	52.4	52.4	52.4	500.0
2010-11-01 07:00:00	QQQ	ETF	52.4	52.41	52.37	52.37	13046.0
2010-11-01 07:30:00	QQQ	ETF	52.35	52.4	52.34	52.34	8234.0
2010-11-01 08:00:00	QQQ	ETF	52.32	52.36	52.3	52.3	57797.0
2010-11-01 08:30:00	QQQ	ETF	52.3	52.38	52.25	52.34	522553.0
2010-11-01 09:00:00	QQQ	ETF	52.35	52.38	52.32	52.37	302565.0
2010-11-01 09:30:00	QQQ	ETF	52.38	52.68	52.37	52.5999	7156289.0
2010-11-01 10:00:00	QQQ	ETF	52.6	52.75	52.58	52.64	6941498.0
2010-11-01 10:30:00	QQQ	ETF	52.64	52.66	52.44	52.47	2503046.0
2010-11-01 11:00:00	QQQ	ETF	52.46	52.4625	52.15	52.2	5410994.0
2010-11-01 11:30:00	QQQ	ETF	52.19	52.3	52.1	52.3	4070030.0
2010-11-01 12:00:00	QQQ	ETF	52.31	52.37	52.24	52.34	2401901.0
2010-11-01 12:30:00	QQQ	ETF	52.35	52.36	52.24	52.29	1280838.0

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

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