PREVIEW / etf_30min / 2015-09-01

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-09-01.parquet
  size:    418 KB
  rows:    14,227

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
2015-09-01 04:00:00	SPY	ETF	193.47	193.65	193.18	193.45	45860.0
2015-09-01 04:30:00	SPY	ETF	193.48	193.48	192.8	192.93	87894.0
2015-09-01 05:00:00	SPY	ETF	192.89	193.6	192.83	192.88	123847.0
2015-09-01 05:30:00	SPY	ETF	192.91	193.58	192.81	193.33	96965.0
2015-09-01 06:00:00	SPY	ETF	193.35	193.93	193.35	193.93	100244.0
2015-09-01 06:30:00	SPY	ETF	193.9	194.06	193.41	193.82	328575.0
2015-09-01 07:00:00	SPY	ETF	193.81	194.26	193.69	194.06	441756.0
2015-09-01 07:30:00	SPY	ETF	194.06	194.06	193.51	193.7	563184.0
2015-09-01 08:00:00	SPY	ETF	193.72	194.23	193.0	193.53	1238954.0
2015-09-01 08:30:00	SPY	ETF	193.52	193.53	192.25	192.32	2423505.0
2015-09-01 09:00:00	SPY	ETF	192.33	193.22	192.25	193.13	2797198.0
2015-09-01 09:30:00	SPY	ETF	193.12	194.77	193.0	193.91	38750743.0
2015-09-01 10:00:00	SPY	ETF	193.89	194.21	193.0	194.21	23576627.0
2015-09-01 10:30:00	SPY	ETF	194.2	194.67	193.33	193.8	14451884.0
2015-09-01 11:00:00	SPY	ETF	193.8	194.475	193.37	193.98	10787086.0
2015-09-01 11:30:00	SPY	ETF	193.975	194.25	193.7	193.79	6076186.0
2015-09-01 12:00:00	SPY	ETF	193.78	194.01	193.11	193.16	7713178.0
2015-09-01 12:30:00	SPY	ETF	193.16	193.28	192.44	192.4864	11212059.0
2015-09-01 13:00:00	SPY	ETF	192.49	193.25	192.25	192.945	16482952.0
2015-09-01 13:30:00	SPY	ETF	192.94	193.26	192.62	193.21	8588235.0
2015-09-01 14:00:00	SPY	ETF	193.21	193.22	192.17	192.47	9038278.0
2015-09-01 14:30:00	SPY	ETF	192.47	193.45	192.39	192.515	14316974.0
2015-09-01 15:00:00	SPY	ETF	192.57	192.75	191.8	191.9	18466684.0
2015-09-01 15:30:00	SPY	ETF	191.89	192.59	190.73	191.61	48060907.0
2015-09-01 16:00:00	SPY	ETF	191.6	194.0	191.17	192.41	6486320.0
2015-09-01 16:30:00	SPY	ETF	192.41	192.44	191.85	192.14	5464073.0
2015-09-01 17:00:00	SPY	ETF	192.05	192.22	191.77	192.05	1180512.0
2015-09-01 17:30:00	SPY	ETF	192.08	192.15	191.8865	192.13	589156.0
2015-09-01 18:00:00	SPY	ETF	192.13	192.13	191.57	191.61	202635.0
2015-09-01 18:30:00	SPY	ETF	191.62	192.34	191.61	192.17	642255.0
2015-09-01 19:00:00	SPY	ETF	192.19	192.24	191.78	192.1	23130.0
2015-09-01 19:30:00	SPY	ETF	192.11	192.86	192.09	192.74	79198.0
2015-09-01 04:00:00	QQQ	ETF	101.96	101.97	101.1	101.82	17279.0
2015-09-01 04:30:00	QQQ	ETF	102.0	102.0	101.67	101.67	48662.0
2015-09-01 05:00:00	QQQ	ETF	101.83	101.99	101.76	101.88	42500.0
2015-09-01 05:30:00	QQQ	ETF	101.88	102.09	101.87	102.09	20100.0
2015-09-01 06:00:00	QQQ	ETF	101.96	102.22	101.96	102.15	36500.0
2015-09-01 06:30:00	QQQ	ETF	102.26	102.26	101.99	102.14	30228.0
2015-09-01 07:00:00	QQQ	ETF	102.17	102.38	102.14	102.34	129135.0
2015-09-01 07:30:00	QQQ	ETF	102.3	102.3	102.0	102.14	102138.0
2015-09-01 08:00:00	QQQ	ETF	102.12	102.18	101.84	102.0	154095.0
2015-09-01 08:30:00	QQQ	ETF	102.01	102.01	101.35	101.42	345012.0
2015-09-01 09:00:00	QQQ	ETF	101.4	101.9	101.37	101.72	707160.0
2015-09-01 09:30:00	QQQ	ETF	101.71	103.18	101.68	102.65	11643942.0
2015-09-01 10:00:00	QQQ	ETF	102.65	102.99	102.2	102.99	5821969.0
2015-09-01 10:30:00	QQQ	ETF	102.99	103.29	102.51	102.83	3918404.0
2015-09-01 11:00:00	QQQ	ETF	102.83	103.19	102.53	102.83	2363692.0
2015-09-01 11:30:00	QQQ	ETF	102.8	103.0	102.67	102.755	1640609.0
2015-09-01 12:00:00	QQQ	ETF	102.75	102.87	102.24	102.26	1643340.0
2015-09-01 12:30:00	QQQ	ETF	102.2401	102.3	101.75	101.81	3114472.0

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

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