PREVIEW / etf_30min / 2010-08-25

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-08-25.parquet
  size:    265 KB
  rows:    8,752

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-08-25 04:00:00	SPY	ETF	106.0	106.0	105.98	106.0	1370.0
2010-08-25 04:30:00	SPY	ETF	105.92	105.92	105.92	105.92	100.0
2010-08-25 05:00:00	SPY	ETF	105.7	105.7	105.7	105.7	300.0
2010-08-25 05:30:00	SPY	ETF	105.68	105.68	105.43	105.43	600.0
2010-08-25 06:00:00	SPY	ETF	105.5	105.5	105.36	105.43	4500.0
2010-08-25 06:30:00	SPY	ETF	105.51	105.57	105.48	105.48	18300.0
2010-08-25 07:00:00	SPY	ETF	105.54	105.54	105.23	105.27	187330.0
2010-08-25 07:30:00	SPY	ETF	105.26	105.41	105.18	105.38	492413.0
2010-08-25 08:00:00	SPY	ETF	105.38	105.38	105.11	105.2	797782.0
2010-08-25 08:30:00	SPY	ETF	105.15	105.15	104.66	104.84	3642633.0
2010-08-25 09:00:00	SPY	ETF	104.84	105.56	104.71	104.94	3703476.0
2010-08-25 09:30:00	SPY	ETF	104.95	105.31	104.49	104.71	36066721.0
2010-08-25 10:00:00	SPY	ETF	104.71	105.06	104.29	104.87	26254577.0
2010-08-25 10:30:00	SPY	ETF	104.86	105.16	104.52	105.11	17262973.0
2010-08-25 11:00:00	SPY	ETF	105.11	105.44	104.91	105.38	23812094.0
2010-08-25 11:30:00	SPY	ETF	105.37	105.37	105.09	105.268	7614094.0
2010-08-25 12:00:00	SPY	ETF	105.26	105.38	105.09	105.13	7081646.0
2010-08-25 12:30:00	SPY	ETF	105.13	105.26	104.92	105.01	7187519.0
2010-08-25 13:00:00	SPY	ETF	105.01	105.25	104.94	105.09	13702336.0
2010-08-25 13:30:00	SPY	ETF	105.09	105.44	105.04	105.33	8514008.0
2010-08-25 14:00:00	SPY	ETF	105.33	105.64	105.2125	105.45	14655120.0
2010-08-25 14:30:00	SPY	ETF	105.45	106.02	105.4	105.98	18426826.0
2010-08-25 15:00:00	SPY	ETF	105.98	106.06	105.63	105.68	14060963.0
2010-08-25 15:30:00	SPY	ETF	105.68	106.34	105.67	105.93	37796557.0
2010-08-25 16:00:00	SPY	ETF	105.93	106.285	104.805	106.08	23213887.0
2010-08-25 16:30:00	SPY	ETF	106.06	106.17	105.85	106.06	3493801.0
2010-08-25 17:00:00	SPY	ETF	106.08	106.11	106.04	106.06	39760.0
2010-08-25 17:30:00	SPY	ETF	106.09	106.09	106.01	106.03	32224.0
2010-08-25 18:00:00	SPY	ETF	106.03	106.06	105.88	106.02	36675.0
2010-08-25 18:30:00	SPY	ETF	106.02	106.06	106.02	106.06	37790.0
2010-08-25 19:00:00	SPY	ETF	106.06	106.17	106.06	106.17	40787.0
2010-08-25 19:30:00	SPY	ETF	106.18	106.2	106.12	106.2	46296.0
2010-08-25 06:00:00	QQQ	ETF	43.53	43.54	43.53	43.54	10200.0
2010-08-25 07:00:00	QQQ	ETF	43.59	43.59	43.49	43.49	86900.0
2010-08-25 07:30:00	QQQ	ETF	43.48	43.54	43.46	43.52	12450.0
2010-08-25 08:00:00	QQQ	ETF	43.53	43.54	43.41	43.48	223160.0
2010-08-25 08:30:00	QQQ	ETF	43.43	43.43	43.25	43.29	985820.0
2010-08-25 09:00:00	QQQ	ETF	43.29	43.36	43.23	43.35	388987.0
2010-08-25 09:30:00	QQQ	ETF	43.35	43.62	43.33	43.43	11914974.0
2010-08-25 10:00:00	QQQ	ETF	43.44	43.63	43.27	43.5299	9224654.0
2010-08-25 10:30:00	QQQ	ETF	43.52	43.67	43.37	43.65	4920024.0
2010-08-25 11:00:00	QQQ	ETF	43.64	43.82	43.53	43.79	17381766.0
2010-08-25 11:30:00	QQQ	ETF	43.79	43.79	43.66	43.74	1681560.0
2010-08-25 12:00:00	QQQ	ETF	43.7491	43.8	43.69	43.7016	1598458.0
2010-08-25 12:30:00	QQQ	ETF	43.7	43.745	43.58	43.6475	1530887.0
2010-08-25 13:00:00	QQQ	ETF	43.64	43.7	43.6	43.62	2458293.0
2010-08-25 13:30:00	QQQ	ETF	43.62	43.79	43.6	43.73	2407801.0
2010-08-25 14:00:00	QQQ	ETF	43.73	43.86	43.72	43.8	2988323.0
2010-08-25 14:30:00	QQQ	ETF	43.81	44.07	43.77	44.05	6728403.0
2010-08-25 15:00:00	QQQ	ETF	44.05	44.1	43.93	43.96	4514575.0

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

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