PREVIEW / etf_30min / 2017-03-23

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-03-23.parquet
  size:    424 KB
  rows:    14,428

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
2017-03-23 04:00:00	SPY	ETF	234.25	234.25	234.15	234.15	603.0
2017-03-23 04:30:00	SPY	ETF	234.17	234.17	234.0	234.12	4136.0
2017-03-23 05:00:00	SPY	ETF	234.12	234.35	234.09	234.35	21924.0
2017-03-23 05:30:00	SPY	ETF	234.37	234.38	234.2	234.2	6902.0
2017-03-23 06:00:00	SPY	ETF	234.29	234.29	234.17	234.17	3952.0
2017-03-23 06:30:00	SPY	ETF	234.39	234.5	234.39	234.5	6050.0
2017-03-23 07:00:00	SPY	ETF	234.51	234.58	234.41	234.48	34787.0
2017-03-23 07:30:00	SPY	ETF	234.48	234.51	234.37	234.46	36533.0
2017-03-23 08:00:00	SPY	ETF	234.51	234.58	234.4	234.52	187617.0
2017-03-23 08:30:00	SPY	ETF	234.5	234.5	234.12	234.19	409387.0
2017-03-23 09:00:00	SPY	ETF	234.18	234.28	233.87	233.98	1221149.0
2017-03-23 09:30:00	SPY	ETF	234.0	234.45	233.72	234.16	7970066.0
2017-03-23 10:00:00	SPY	ETF	234.16	234.43	234.08	234.3	4668840.0
2017-03-23 10:30:00	SPY	ETF	234.3	234.97	234.24	234.77	6628577.0
2017-03-23 11:00:00	SPY	ETF	234.78	235.34	234.75	235.15	6386015.0
2017-03-23 11:30:00	SPY	ETF	235.1585	235.23	235.01	235.06	5078938.0
2017-03-23 12:00:00	SPY	ETF	235.06	235.29	235.04	235.1975	5687353.0
2017-03-23 12:30:00	SPY	ETF	235.2	235.31	235.055	235.28	2772821.0
2017-03-23 13:00:00	SPY	ETF	235.29	235.29	234.2847	234.3189	8783779.0
2017-03-23 13:30:00	SPY	ETF	234.31	234.88	234.3	234.69	4280741.0
2017-03-23 14:00:00	SPY	ETF	234.7	234.83	234.63	234.68	1696352.0
2017-03-23 14:30:00	SPY	ETF	234.675	234.96	234.53	234.61	3815364.0
2017-03-23 15:00:00	SPY	ETF	234.61	234.655	233.91	233.94	8852049.0
2017-03-23 15:30:00	SPY	ETF	233.94	234.2	233.6	234.01	19188964.0
2017-03-23 16:00:00	SPY	ETF	234.0	234.6665	233.67	233.81	7703265.0
2017-03-23 16:30:00	SPY	ETF	233.81	234.03	233.77	233.86	1168573.0
2017-03-23 17:00:00	SPY	ETF	233.85	233.88	233.74	233.75	150233.0
2017-03-23 17:30:00	SPY	ETF	233.77	233.85	233.75	233.8	77156.0
2017-03-23 18:00:00	SPY	ETF	233.83	234.22	233.83	234.22	105691.0
2017-03-23 18:30:00	SPY	ETF	234.22	234.22	234.0	234.0	48624.0
2017-03-23 19:00:00	SPY	ETF	234.0	234.2	233.99	234.2	16802.0
2017-03-23 19:30:00	SPY	ETF	234.16	234.16	234.02	234.05	13747.0
2017-03-23 04:00:00	QQQ	ETF	130.78	130.78	130.55	130.55	42598.0
2017-03-23 04:30:00	QQQ	ETF	130.55	130.57	130.51	130.51	20000.0
2017-03-23 05:00:00	QQQ	ETF	130.52	130.57	130.52	130.57	600.0
2017-03-23 05:30:00	QQQ	ETF	130.59	130.59	130.59	130.59	499.0
2017-03-23 06:00:00	QQQ	ETF	130.63	130.64	130.58	130.6	6298.0
2017-03-23 06:30:00	QQQ	ETF	130.58	130.72	130.58	130.72	700.0
2017-03-23 07:00:00	QQQ	ETF	130.76	130.81	130.76	130.76	2800.0
2017-03-23 07:30:00	QQQ	ETF	130.76	130.76	130.73	130.75	2500.0
2017-03-23 08:00:00	QQQ	ETF	130.77	130.84	130.72	130.81	84356.0
2017-03-23 08:30:00	QQQ	ETF	130.78	130.78	130.6	130.6	48490.0
2017-03-23 09:00:00	QQQ	ETF	130.59	130.59	130.49	130.51	105327.0
2017-03-23 09:30:00	QQQ	ETF	130.52	130.67	130.251	130.375	2211599.0
2017-03-23 10:00:00	QQQ	ETF	130.37	130.48	130.171	130.36	1367464.0
2017-03-23 10:30:00	QQQ	ETF	130.37	130.765	130.3268	130.65	974469.0
2017-03-23 11:00:00	QQQ	ETF	130.65	130.88	130.62	130.795	1137172.0
2017-03-23 11:30:00	QQQ	ETF	130.8	130.825	130.69	130.812	515092.0
2017-03-23 12:00:00	QQQ	ETF	130.8	130.88	130.75	130.83	518201.0
2017-03-23 12:30:00	QQQ	ETF	130.83	130.8653	130.725	130.84	394325.0

> showing 50 of 14,428 rows — these rows as CSV

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