PREVIEW / etf_30min / 2010-09-29

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-09-29.parquet
  size:    256 KB
  rows:    8,610

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-09-29 04:00:00	SPY	ETF	114.5	114.54	114.24	114.43	10500.0
2010-09-29 04:30:00	SPY	ETF	114.32	114.32	114.19	114.21	2980.0
2010-09-29 05:00:00	SPY	ETF	114.4	114.4	114.35	114.37	1200.0
2010-09-29 05:30:00	SPY	ETF	114.46	114.75	114.46	114.64	12060.0
2010-09-29 06:00:00	SPY	ETF	114.64	114.64	114.41	114.46	6160.0
2010-09-29 06:30:00	SPY	ETF	114.54	114.59	114.52	114.54	1200.0
2010-09-29 07:00:00	SPY	ETF	114.59	114.59	114.4	114.48	108850.0
2010-09-29 07:30:00	SPY	ETF	114.53	114.69	114.53	114.69	204205.0
2010-09-29 08:00:00	SPY	ETF	114.7	114.81	114.42	114.6	937434.0
2010-09-29 08:30:00	SPY	ETF	114.78	114.78	114.39	114.41	1487914.0
2010-09-29 09:00:00	SPY	ETF	114.42	114.48	114.29	114.39	1977820.0
2010-09-29 09:30:00	SPY	ETF	114.38	114.68	114.2	114.33	23462153.0
2010-09-29 10:00:00	SPY	ETF	114.34	114.65	114.02	114.23	19094412.0
2010-09-29 10:30:00	SPY	ETF	114.23	114.41	114.07	114.2499	14250809.0
2010-09-29 11:00:00	SPY	ETF	114.24	114.6199	114.21	114.43	9737312.0
2010-09-29 11:30:00	SPY	ETF	114.43	114.74	114.42	114.67	8799222.0
2010-09-29 12:00:00	SPY	ETF	114.66	114.86	114.57	114.75	8627425.0
2010-09-29 12:30:00	SPY	ETF	114.75	114.76	114.58	114.68	5219143.0
2010-09-29 13:00:00	SPY	ETF	114.68	114.75	114.53	114.5496	5091421.0
2010-09-29 13:30:00	SPY	ETF	114.54	114.78	114.43	114.725	10327221.0
2010-09-29 14:00:00	SPY	ETF	114.73	114.91	114.66	114.675	7230903.0
2010-09-29 14:30:00	SPY	ETF	114.68	114.89	114.66	114.82	5446872.0
2010-09-29 15:00:00	SPY	ETF	114.83	114.84	114.17	114.33	16392604.0
2010-09-29 15:30:00	SPY	ETF	114.32	114.7826	114.07	114.43	27099806.0
2010-09-29 16:00:00	SPY	ETF	114.43	114.805	114.125	114.54	10761383.0
2010-09-29 16:30:00	SPY	ETF	114.55	114.56	114.43	114.51	2195763.0
2010-09-29 17:00:00	SPY	ETF	114.51	114.54	114.43	114.49	60113.0
2010-09-29 17:30:00	SPY	ETF	114.48	114.53	114.46	114.48	46772.0
2010-09-29 18:00:00	SPY	ETF	114.41	114.54	114.41	114.5	8284.0
2010-09-29 18:30:00	SPY	ETF	114.5	114.54	114.5	114.5	21000.0
2010-09-29 19:00:00	SPY	ETF	114.5	114.5	114.45	114.46	14510.0
2010-09-29 19:30:00	SPY	ETF	114.46	114.5	114.46	114.47	45367.0
2010-09-29 05:00:00	QQQ	ETF	49.27	49.31	49.27	49.31	7500.0
2010-09-29 05:30:00	QQQ	ETF	49.35	49.35	49.35	49.35	1500.0
2010-09-29 06:30:00	QQQ	ETF	49.36	49.36	49.36	49.36	100.0
2010-09-29 07:00:00	QQQ	ETF	49.34	49.36	49.31	49.35	5500.0
2010-09-29 07:30:00	QQQ	ETF	49.37	49.38	49.36	49.38	10215.0
2010-09-29 08:00:00	QQQ	ETF	49.4	49.48	49.37	49.37	87652.0
2010-09-29 08:30:00	QQQ	ETF	49.37	49.43	49.32	49.32	122479.0
2010-09-29 09:00:00	QQQ	ETF	49.31	49.41	49.26	49.3	1253939.0
2010-09-29 09:30:00	QQQ	ETF	49.3	49.53	49.2	49.32	10639772.0
2010-09-29 10:00:00	QQQ	ETF	49.31	49.5	49.13	49.24	7613003.0
2010-09-29 10:30:00	QQQ	ETF	49.24	49.32	49.15	49.23	2972300.0
2010-09-29 11:00:00	QQQ	ETF	49.23	49.34	49.22	49.32	3213464.0
2010-09-29 11:30:00	QQQ	ETF	49.32	49.42	49.32	49.36	2285949.0
2010-09-29 12:00:00	QQQ	ETF	49.37	49.45	49.28	49.4	5149811.0
2010-09-29 12:30:00	QQQ	ETF	49.39	49.4	49.33	49.35	2558426.0
2010-09-29 13:00:00	QQQ	ETF	49.355	49.39	49.27	49.29	2956466.0
2010-09-29 13:30:00	QQQ	ETF	49.29	49.39	49.18	49.36	5171139.0
2010-09-29 14:00:00	QQQ	ETF	49.355	49.43	49.3	49.32	2467632.0

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

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