PREVIEW / etf_30min / 2015-06-12

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-06-12.parquet
  size:    355 KB
  rows:    12,084

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-06-12 04:00:00	SPY	ETF	211.21	211.21	210.9	211.0	4295.0
2015-06-12 04:30:00	SPY	ETF	211.2	211.2	211.03	211.03	29400.0
2015-06-12 05:00:00	SPY	ETF	210.95	211.12	210.95	211.0	37291.0
2015-06-12 05:30:00	SPY	ETF	211.05	211.45	211.02	211.45	6541.0
2015-06-12 06:00:00	SPY	ETF	211.28	211.48	211.26	211.45	9500.0
2015-06-12 06:30:00	SPY	ETF	211.32	211.32	211.03	211.13	39800.0
2015-06-12 07:00:00	SPY	ETF	211.16	211.19	210.86	210.86	162238.0
2015-06-12 07:30:00	SPY	ETF	210.86	210.86	210.62	210.85	326646.0
2015-06-12 08:00:00	SPY	ETF	210.86	210.99	210.71	210.76	466024.0
2015-06-12 08:30:00	SPY	ETF	210.79	210.87	210.68	210.77	300503.0
2015-06-12 09:00:00	SPY	ETF	210.77	210.84	210.55	210.63	512744.0
2015-06-12 09:30:00	SPY	ETF	210.64	210.84	210.13	210.41	18178239.0
2015-06-12 10:00:00	SPY	ETF	210.42	210.73	210.14	210.25	12814723.0
2015-06-12 10:30:00	SPY	ETF	210.25	210.34	209.71	209.75	13299385.0
2015-06-12 11:00:00	SPY	ETF	209.75	210.54	209.68	210.41	13168368.0
2015-06-12 11:30:00	SPY	ETF	210.42	210.46	209.995	210.07	7325698.0
2015-06-12 12:00:00	SPY	ETF	210.065	210.17	209.89	210.13	6368799.0
2015-06-12 12:30:00	SPY	ETF	210.12	210.15	209.915	209.96	3895946.0
2015-06-12 13:00:00	SPY	ETF	209.9657	210.14	209.92	210.1275	2903073.0
2015-06-12 13:30:00	SPY	ETF	210.14	210.3	210.0	210.1887	5348887.0
2015-06-12 14:00:00	SPY	ETF	210.19	210.2	209.96	210.0	5899334.0
2015-06-12 14:30:00	SPY	ETF	210.0	211.482	209.72	209.76	9515740.0
2015-06-12 15:00:00	SPY	ETF	209.76	210.08	209.72	210.05	7099295.0
2015-06-12 15:30:00	SPY	ETF	210.07	210.2	209.93	210.0	12090502.0
2015-06-12 16:00:00	SPY	ETF	209.99	211.4734	209.83	209.98	7791282.0
2015-06-12 16:30:00	SPY	ETF	209.99	210.04	209.96	210.01	5392594.0
2015-06-12 17:00:00	SPY	ETF	210.01	210.1389	209.96	210.02	134536.0
2015-06-12 17:30:00	SPY	ETF	210.0	210.04	209.97	210.0	28065.0
2015-06-12 18:00:00	SPY	ETF	209.97	210.05	209.97	209.97	25340.0
2015-06-12 18:30:00	SPY	ETF	210.03	210.03	209.98	209.99	1000.0
2015-06-12 19:00:00	SPY	ETF	210.0	210.0	209.95	209.98	8595.0
2015-06-12 19:30:00	SPY	ETF	209.97	209.99	209.96	209.99	4841.0
2015-06-12 04:00:00	QQQ	ETF	109.46	109.46	109.24	109.24	9750.0
2015-06-12 05:00:00	QQQ	ETF	109.23	109.23	109.22	109.22	1555.0
2015-06-12 05:30:00	QQQ	ETF	109.53	109.53	109.53	109.53	500.0
2015-06-12 06:00:00	QQQ	ETF	109.49	109.55	109.49	109.55	900.0
2015-06-12 07:00:00	QQQ	ETF	109.4	109.4	109.25	109.25	5125.0
2015-06-12 07:30:00	QQQ	ETF	109.21	109.21	109.01	109.15	45197.0
2015-06-12 08:00:00	QQQ	ETF	109.08	109.21	109.07	109.1	156021.0
2015-06-12 08:30:00	QQQ	ETF	109.097	109.15	109.05	109.05	126310.0
2015-06-12 09:00:00	QQQ	ETF	109.05	109.09	108.98	109.05	88127.0
2015-06-12 09:30:00	QQQ	ETF	109.07	109.29	108.87	109.01	3856953.0
2015-06-12 10:00:00	QQQ	ETF	109.03	109.3	108.96	109.03	2294783.0
2015-06-12 10:30:00	QQQ	ETF	109.025	109.07	108.65	108.67	2842046.0
2015-06-12 11:00:00	QQQ	ETF	108.66	109.03	108.6	108.96	1929183.0
2015-06-12 11:30:00	QQQ	ETF	108.965	108.98	108.75	108.795	929187.0
2015-06-12 12:00:00	QQQ	ETF	108.795	108.9099	108.68	108.875	2659649.0
2015-06-12 12:30:00	QQQ	ETF	108.88	108.89	108.78	108.8	474909.0
2015-06-12 13:00:00	QQQ	ETF	108.805	108.87	108.77	108.8542	831073.0
2015-06-12 13:30:00	QQQ	ETF	108.855	108.95	108.81	108.91	650641.0

> showing 50 of 12,084 rows — these rows as CSV

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