PREVIEW / etf_30min / 2010-10-07

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-10-07.parquet
  size:    260 KB
  rows:    8,656

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-07 04:00:00	SPY	ETF	116.11	116.11	116.11	116.11	700.0
2010-10-07 04:30:00	SPY	ETF	116.03	116.03	116.03	116.03	100.0
2010-10-07 05:00:00	SPY	ETF	115.9	116.1	115.9	116.1	10700.0
2010-10-07 05:30:00	SPY	ETF	115.9	115.9	115.9	115.9	4400.0
2010-10-07 06:00:00	SPY	ETF	116.09	116.2	116.09	116.2	45350.0
2010-10-07 06:30:00	SPY	ETF	116.13	116.16	116.13	116.16	7500.0
2010-10-07 07:00:00	SPY	ETF	116.16	116.21	116.16	116.21	62475.0
2010-10-07 07:30:00	SPY	ETF	116.19	116.22	116.02	116.02	67900.0
2010-10-07 08:00:00	SPY	ETF	116.01	116.2	115.94	116.15	727476.0
2010-10-07 08:30:00	SPY	ETF	116.15	116.83	116.09	116.68	3132531.0
2010-10-07 09:00:00	SPY	ETF	116.68	116.81	116.5	116.5	1080991.0
2010-10-07 09:30:00	SPY	ETF	116.5	116.53	115.73	115.77	25531647.0
2010-10-07 10:00:00	SPY	ETF	115.78	116.2	115.68	116.19	19595822.0
2010-10-07 10:30:00	SPY	ETF	116.2	116.26	115.9	115.97	11374306.0
2010-10-07 11:00:00	SPY	ETF	115.97	115.98	115.75	115.81	9655282.0
2010-10-07 11:30:00	SPY	ETF	115.81	116.0	115.7	115.83	5527566.0
2010-10-07 12:00:00	SPY	ETF	115.83	115.87	115.46	115.5	8043119.0
2010-10-07 12:30:00	SPY	ETF	115.5075	115.5075	115.19	115.4	12882833.0
2010-10-07 13:00:00	SPY	ETF	115.3938	115.6	115.33	115.5066	9855119.0
2010-10-07 13:30:00	SPY	ETF	115.5	115.82	115.37	115.74	9261619.0
2010-10-07 14:00:00	SPY	ETF	115.73	115.96	115.66	115.81	10643866.0
2010-10-07 14:30:00	SPY	ETF	115.81	115.9	115.7	115.89	7886218.0
2010-10-07 15:00:00	SPY	ETF	115.89	115.94	115.76	115.79	5383546.0
2010-10-07 15:30:00	SPY	ETF	115.78	116.01	115.69	115.89	15140637.0
2010-10-07 16:00:00	SPY	ETF	115.89	116.435	115.795	116.11	6321528.0
2010-10-07 16:30:00	SPY	ETF	116.11	116.13	115.89	116.06	284845.0
2010-10-07 17:00:00	SPY	ETF	116.07	116.14	116.04	116.13	66726.0
2010-10-07 17:30:00	SPY	ETF	116.13	116.2	116.13	116.15	149258.0
2010-10-07 18:00:00	SPY	ETF	116.14	116.16	115.89	116.15	114525.0
2010-10-07 18:30:00	SPY	ETF	116.15	116.15	116.13	116.15	9638.0
2010-10-07 19:00:00	SPY	ETF	116.14	116.17	116.14	116.15	7700.0
2010-10-07 19:30:00	SPY	ETF	116.16	116.18	116.14	116.18	28375.0
2010-10-07 06:00:00	QQQ	ETF	49.26	49.26	49.26	49.26	460.0
2010-10-07 06:30:00	QQQ	ETF	49.27	49.27	49.27	49.27	15500.0
2010-10-07 07:00:00	QQQ	ETF	49.25	49.3	49.25	49.29	25952.0
2010-10-07 07:30:00	QQQ	ETF	49.28	49.29	49.21	49.22	94562.0
2010-10-07 08:00:00	QQQ	ETF	49.21	49.3	49.1	49.12	105441.0
2010-10-07 08:30:00	QQQ	ETF	49.23	49.6	49.19	49.58	1013381.0
2010-10-07 09:00:00	QQQ	ETF	49.58	49.63	49.51	49.52	826585.0
2010-10-07 09:30:00	QQQ	ETF	49.52	49.53	49.05	49.08	10010692.0
2010-10-07 10:00:00	QQQ	ETF	49.07	49.51	49.0	49.5001	11430893.0
2010-10-07 10:30:00	QQQ	ETF	49.51	49.54	49.38	49.4	5297992.0
2010-10-07 11:00:00	QQQ	ETF	49.39	49.39	49.27	49.31	2918014.0
2010-10-07 11:30:00	QQQ	ETF	49.31	49.43	49.26	49.3299	6334784.0
2010-10-07 12:00:00	QQQ	ETF	49.32	49.34	49.15	49.18	2369264.0
2010-10-07 12:30:00	QQQ	ETF	49.18	49.18	49.03	49.1296	3565780.0
2010-10-07 13:00:00	QQQ	ETF	49.13	49.3	49.09	49.205	5607072.0
2010-10-07 13:30:00	QQQ	ETF	49.21	49.36	49.14	49.31	2898249.0
2010-10-07 14:00:00	QQQ	ETF	49.31	49.409	49.23	49.3	6842924.0
2010-10-07 14:30:00	QQQ	ETF	49.3	49.36	49.27	49.36	2272591.0

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

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