PREVIEW / etf_30min / 2010-11-19

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-11-19.parquet
  size:    261 KB
  rows:    8,686

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-19 04:00:00	SPY	ETF	120.2	120.2	120.08	120.08	6900.0
2010-11-19 05:00:00	SPY	ETF	119.99	119.99	119.95	119.95	1339.0
2010-11-19 05:30:00	SPY	ETF	119.88	120.06	119.76	119.96	14740.0
2010-11-19 06:00:00	SPY	ETF	119.86	119.9	119.81	119.83	5451.0
2010-11-19 06:30:00	SPY	ETF	119.94	120.02	119.94	119.96	41600.0
2010-11-19 07:00:00	SPY	ETF	119.96	119.98	119.69	119.69	228146.0
2010-11-19 07:30:00	SPY	ETF	119.68	119.75	119.56	119.64	247310.0
2010-11-19 08:00:00	SPY	ETF	119.66	119.77	119.58	119.7	481758.0
2010-11-19 08:30:00	SPY	ETF	119.7	119.93	119.69	119.75	1509125.0
2010-11-19 09:00:00	SPY	ETF	119.74	119.92	119.71	119.9	1218121.0
2010-11-19 09:30:00	SPY	ETF	119.9	119.92	119.25	119.48	22844784.0
2010-11-19 10:00:00	SPY	ETF	119.48	119.53	119.26	119.42	11563120.0
2010-11-19 10:30:00	SPY	ETF	119.425	119.86	119.32	119.7	11149946.0
2010-11-19 11:00:00	SPY	ETF	119.699	119.87	119.63	119.81	8728824.0
2010-11-19 11:30:00	SPY	ETF	119.81	119.98	119.8	119.82	7851917.0
2010-11-19 12:00:00	SPY	ETF	119.82	119.89	119.79	119.8	3953395.0
2010-11-19 12:30:00	SPY	ETF	119.805	120.05	119.75	120.03	4880277.0
2010-11-19 13:00:00	SPY	ETF	120.029	120.13	119.95	119.97	6383711.0
2010-11-19 13:30:00	SPY	ETF	119.97	120.08	119.96	120.05	4232161.0
2010-11-19 14:00:00	SPY	ETF	120.05	120.23	120.01	120.11	6584691.0
2010-11-19 14:30:00	SPY	ETF	120.1175	120.23	120.06	120.105	8755981.0
2010-11-19 15:00:00	SPY	ETF	120.1	120.18	120.01	120.02	5363803.0
2010-11-19 15:30:00	SPY	ETF	120.05	120.34	119.96	120.28	23332354.0
2010-11-19 16:00:00	SPY	ETF	120.27	120.48	119.345	120.34	13925480.0
2010-11-19 16:30:00	SPY	ETF	120.38	120.4109	118.188	120.36	8050432.0
2010-11-19 17:00:00	SPY	ETF	120.31	120.35	120.3	120.34	21135.0
2010-11-19 17:30:00	SPY	ETF	120.35	120.35	120.3	120.31	10985.0
2010-11-19 18:00:00	SPY	ETF	120.35	120.35	120.26	120.33	15515.0
2010-11-19 18:30:00	SPY	ETF	120.33	120.33	120.28	120.32	5900.0
2010-11-19 19:00:00	SPY	ETF	120.32	120.35	120.29	120.32	7100.0
2010-11-19 19:30:00	SPY	ETF	120.32	120.32	120.25	120.25	21976.0
2010-11-19 04:00:00	QQQ	ETF	52.36	52.36	52.36	52.36	450.0
2010-11-19 04:30:00	QQQ	ETF	52.35	52.35	52.35	52.35	100.0
2010-11-19 06:00:00	QQQ	ETF	52.34	52.34	52.34	52.34	1000.0
2010-11-19 06:30:00	QQQ	ETF	52.34	52.39	52.34	52.36	1300.0
2010-11-19 07:00:00	QQQ	ETF	52.35	52.35	52.27	52.27	26900.0
2010-11-19 07:30:00	QQQ	ETF	52.26	52.28	52.21	52.24	106009.0
2010-11-19 08:00:00	QQQ	ETF	52.26	52.29	52.23	52.28	137612.0
2010-11-19 08:30:00	QQQ	ETF	52.28	52.36	52.27	52.31	221383.0
2010-11-19 09:00:00	QQQ	ETF	52.31	52.37	52.29	52.34	426716.0
2010-11-19 09:30:00	QQQ	ETF	52.34	52.4	52.15	52.24	8922139.0
2010-11-19 10:00:00	QQQ	ETF	52.2376	52.28	52.14	52.21	4302936.0
2010-11-19 10:30:00	QQQ	ETF	52.215	52.43	52.17	52.36	6273092.0
2010-11-19 11:00:00	QQQ	ETF	52.37	52.4101	52.27	52.35	3179618.0
2010-11-19 11:30:00	QQQ	ETF	52.355	52.45	52.35	52.4	1984335.0
2010-11-19 12:00:00	QQQ	ETF	52.4	52.43	52.365	52.365	1043971.0
2010-11-19 12:30:00	QQQ	ETF	52.365	52.5	52.3375	52.4901	3326790.0
2010-11-19 13:00:00	QQQ	ETF	52.4999	52.54	52.48	52.49	2344647.0
2010-11-19 13:30:00	QQQ	ETF	52.4958	52.53	52.49	52.52	869405.0
2010-11-19 14:00:00	QQQ	ETF	52.53	52.59	52.5099	52.55	1337247.0

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

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