PREVIEW / etf_30min / 2016-01-29

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-01-29.parquet
  size:    407 KB
  rows:    13,649

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
2016-01-29 04:00:00	SPY	ETF	190.13	190.75	190.13	190.4	11561.0
2016-01-29 04:30:00	SPY	ETF	190.39	190.82	190.39	190.58	35750.0
2016-01-29 05:00:00	SPY	ETF	190.54	190.75	190.07	190.17	13600.0
2016-01-29 05:30:00	SPY	ETF	190.17	190.23	189.73	190.0	28590.0
2016-01-29 06:00:00	SPY	ETF	189.92	190.1	189.75	189.75	8995.0
2016-01-29 06:30:00	SPY	ETF	189.7	190.04	189.69	189.99	60100.0
2016-01-29 07:00:00	SPY	ETF	190.04	190.38	189.97	189.97	208947.0
2016-01-29 07:30:00	SPY	ETF	190.0	190.33	189.83	189.84	257126.0
2016-01-29 08:00:00	SPY	ETF	189.99	190.75	189.08	189.59	629682.0
2016-01-29 08:30:00	SPY	ETF	189.57	190.25	189.38	190.14	1084215.0
2016-01-29 09:00:00	SPY	ETF	190.15	190.29	189.81	190.02	865145.0
2016-01-29 09:30:00	SPY	ETF	190.02	191.24	189.88	191.1525	18693849.0
2016-01-29 10:00:00	SPY	ETF	191.15	191.7	191.04	191.11	14496898.0
2016-01-29 10:30:00	SPY	ETF	191.1	191.32	190.84	191.05	9290247.0
2016-01-29 11:00:00	SPY	ETF	191.045	191.61	191.02	191.21	9126520.0
2016-01-29 11:30:00	SPY	ETF	191.21	191.97	190.99	191.91	12907614.0
2016-01-29 12:00:00	SPY	ETF	191.92	192.35	191.75	192.26	10214526.0
2016-01-29 12:30:00	SPY	ETF	192.26	192.5	192.14	192.42	7358051.0
2016-01-29 13:00:00	SPY	ETF	192.42	192.48	192.18	192.36	7447738.0
2016-01-29 13:30:00	SPY	ETF	192.3569	192.76	192.28	192.52	7746694.0
2016-01-29 14:00:00	SPY	ETF	192.53	192.815	192.21	192.8	7766487.0
2016-01-29 14:30:00	SPY	ETF	192.81	192.94	192.47	192.62	7982491.0
2016-01-29 15:00:00	SPY	ETF	192.62	193.22	192.54	193.1737	15107737.0
2016-01-29 15:30:00	SPY	ETF	193.18	193.75	193.03	193.69	39898434.0
2016-01-29 16:00:00	SPY	ETF	193.71	193.88	193.39	193.5	21539267.0
2016-01-29 16:30:00	SPY	ETF	193.48	193.87	193.44	193.7	3322905.0
2016-01-29 17:00:00	SPY	ETF	193.7	193.89	193.66	193.89	299738.0
2016-01-29 17:30:00	SPY	ETF	193.9	194.01	193.7208	194.0	2938330.0
2016-01-29 18:00:00	SPY	ETF	193.98	194.01	193.97	193.98	53960.0
2016-01-29 18:30:00	SPY	ETF	193.98	193.98	193.91	193.91	31850.0
2016-01-29 19:00:00	SPY	ETF	193.91	193.99	193.91	193.96	22203.0
2016-01-29 19:30:00	SPY	ETF	193.96	194.05	193.95	194.05	43942.0
2016-01-29 04:00:00	QQQ	ETF	102.06	102.33	102.06	102.25	1510.0
2016-01-29 04:30:00	QQQ	ETF	102.3	102.4	102.3	102.4	740.0
2016-01-29 05:00:00	QQQ	ETF	102.37	102.37	102.06	102.06	10500.0
2016-01-29 05:30:00	QQQ	ETF	101.99	101.99	101.9	101.9	700.0
2016-01-29 06:00:00	QQQ	ETF	102.04	102.07	101.84	101.84	16808.0
2016-01-29 06:30:00	QQQ	ETF	102.01	102.01	101.9	101.97	3345.0
2016-01-29 07:00:00	QQQ	ETF	102.01	102.15	102.0	102.05	34362.0
2016-01-29 07:30:00	QQQ	ETF	102.07	102.2	101.96	101.99	62550.0
2016-01-29 08:00:00	QQQ	ETF	101.91	102.43	101.74	101.74	272575.0
2016-01-29 08:30:00	QQQ	ETF	101.75	102.05	101.64	102.02	494061.0
2016-01-29 09:00:00	QQQ	ETF	102.02	102.16	101.82	102.03	295578.0
2016-01-29 09:30:00	QQQ	ETF	102.02	103.01	101.94	102.89	7043269.0
2016-01-29 10:00:00	QQQ	ETF	102.88	103.27	102.8	102.865	4131619.0
2016-01-29 10:30:00	QQQ	ETF	102.86	102.99	102.67	102.75	2489345.0
2016-01-29 11:00:00	QQQ	ETF	102.75	103.05	102.69	102.81	1962995.0
2016-01-29 11:30:00	QQQ	ETF	102.81	103.3	102.8	103.21	2767586.0
2016-01-29 12:00:00	QQQ	ETF	103.22	103.54	103.15	103.459	2482850.0
2016-01-29 12:30:00	QQQ	ETF	103.46	103.65	103.36	103.59	1532146.0

> showing 50 of 13,649 rows — these rows as CSV

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