PREVIEW / etf_30min / 2010-11-16

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-11-16.parquet
  size:    283 KB
  rows:    9,436

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-16 04:00:00	SPY	ETF	119.64	119.64	119.41	119.41	4250.0
2010-11-16 04:30:00	SPY	ETF	119.5	119.52	119.46	119.46	1700.0
2010-11-16 05:00:00	SPY	ETF	119.49	119.49	119.49	119.49	100.0
2010-11-16 05:30:00	SPY	ETF	119.65	119.65	119.35	119.41	10100.0
2010-11-16 06:00:00	SPY	ETF	119.39	119.4	119.19	119.2	71250.0
2010-11-16 06:30:00	SPY	ETF	119.23	119.33	119.16	119.18	110300.0
2010-11-16 07:00:00	SPY	ETF	119.18	119.45	119.18	119.38	585135.0
2010-11-16 07:30:00	SPY	ETF	119.38	119.56	119.34	119.4	444527.0
2010-11-16 08:00:00	SPY	ETF	119.4	119.64	119.21	119.44	1944062.0
2010-11-16 08:30:00	SPY	ETF	119.44	119.69	119.4	119.41	2289225.0
2010-11-16 09:00:00	SPY	ETF	119.41	119.55	119.18	119.28	3254925.0
2010-11-16 09:30:00	SPY	ETF	119.29	119.49	118.94	119.125	29100355.0
2010-11-16 10:00:00	SPY	ETF	119.13	119.42	118.98	119.155	18142618.0
2010-11-16 10:30:00	SPY	ETF	119.1585	119.16	118.55	118.73	24066512.0
2010-11-16 11:00:00	SPY	ETF	118.735	118.75	118.05	118.25	28041516.0
2010-11-16 11:30:00	SPY	ETF	118.25	118.38	117.75	118.06	24191995.0
2010-11-16 12:00:00	SPY	ETF	118.07	118.25	117.93	118.03	22864451.0
2010-11-16 12:30:00	SPY	ETF	118.05	118.14	117.76	118.13	15208425.0
2010-11-16 13:00:00	SPY	ETF	118.13	118.18	117.86	118.14	8878850.0
2010-11-16 13:30:00	SPY	ETF	118.14	118.42	118.04	118.33	16809518.0
2010-11-16 14:00:00	SPY	ETF	118.33	118.36	117.94	118.01	12400971.0
2010-11-16 14:30:00	SPY	ETF	118.01	118.13	117.7	118.01	13624593.0
2010-11-16 15:00:00	SPY	ETF	118.0101	118.15	117.59	117.83	17302017.0
2010-11-16 15:30:00	SPY	ETF	117.82	118.29	117.75	118.15	34382809.0
2010-11-16 16:00:00	SPY	ETF	118.14	120.0823	117.935	118.09	9209803.0
2010-11-16 16:30:00	SPY	ETF	118.09	120.0818	118.06	118.1	2901854.0
2010-11-16 17:00:00	SPY	ETF	118.1	118.17	118.09	118.17	10192150.0
2010-11-16 17:30:00	SPY	ETF	118.16	118.3	118.11	118.29	251275.0
2010-11-16 18:00:00	SPY	ETF	118.29	118.33	118.22	118.29	494303.0
2010-11-16 18:30:00	SPY	ETF	118.3	118.3	118.24	118.29	35577.0
2010-11-16 19:00:00	SPY	ETF	118.29	118.34	118.28	118.31	28328.0
2010-11-16 19:30:00	SPY	ETF	118.31	118.4	118.27	118.4	141971.0
2010-11-16 04:00:00	QQQ	ETF	52.0	52.0	51.95	51.96	20300.0
2010-11-16 04:30:00	QQQ	ETF	51.98	52.0	51.98	52.0	28454.0
2010-11-16 05:00:00	QQQ	ETF	51.99	51.99	51.98	51.98	716.0
2010-11-16 06:00:00	QQQ	ETF	51.85	51.85	51.83	51.85	2900.0
2010-11-16 06:30:00	QQQ	ETF	51.85	51.89	51.85	51.87	2750.0
2010-11-16 07:00:00	QQQ	ETF	51.86	51.93	51.86	51.91	130662.0
2010-11-16 07:30:00	QQQ	ETF	51.92	51.98	51.9	51.91	156458.0
2010-11-16 08:00:00	QQQ	ETF	51.92	52.06	51.89	52.05	343063.0
2010-11-16 08:30:00	QQQ	ETF	51.96	52.07	51.95	51.96	383288.0
2010-11-16 09:00:00	QQQ	ETF	51.95	52.0	51.87	51.92	1066491.0
2010-11-16 09:30:00	QQQ	ETF	51.93	52.2462	51.91	52.0638	9143881.0
2010-11-16 10:00:00	QQQ	ETF	52.06	52.17	51.95	52.01	6946130.0
2010-11-16 10:30:00	QQQ	ETF	52.0	52.005	51.77	51.84	9563792.0
2010-11-16 11:00:00	QQQ	ETF	51.8428	51.85	51.35	51.498	11659701.0
2010-11-16 11:30:00	QQQ	ETF	51.4925	51.58	51.31	51.475	7588875.0
2010-11-16 12:00:00	QQQ	ETF	51.4701	51.6	51.44	51.52	4640086.0
2010-11-16 12:30:00	QQQ	ETF	51.52	51.56	51.39	51.56	4941741.0
2010-11-16 13:00:00	QQQ	ETF	51.56	51.6	51.47	51.59	2688865.0

> showing 50 of 9,436 rows — these rows as CSV

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