PREVIEW / etf_30min / 2015-03-03

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-03-03.parquet
  size:    377 KB
  rows:    12,697

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-03-03 04:00:00	SPY	ETF	211.8	211.8	211.7	211.7	800.0
2015-03-03 04:30:00	SPY	ETF	211.65	211.65	211.65	211.65	100.0
2015-03-03 05:00:00	SPY	ETF	211.69	211.76	211.69	211.75	3150.0
2015-03-03 05:30:00	SPY	ETF	211.75	211.77	211.72	211.77	1100.0
2015-03-03 06:00:00	SPY	ETF	211.75	211.75	211.67	211.7	800.0
2015-03-03 06:30:00	SPY	ETF	211.71	211.71	211.65	211.65	51255.0
2015-03-03 07:00:00	SPY	ETF	211.69	211.69	211.61	211.66	69129.0
2015-03-03 07:30:00	SPY	ETF	211.64	211.66	211.47	211.5	137935.0
2015-03-03 08:00:00	SPY	ETF	211.5	211.69	211.28	211.34	462650.0
2015-03-03 08:30:00	SPY	ETF	211.35	211.99	211.29	211.41	1028094.0
2015-03-03 09:00:00	SPY	ETF	211.38	211.49	211.36	211.47	551629.0
2015-03-03 09:30:00	SPY	ETF	211.47	211.59	210.77	210.9	11709769.0
2015-03-03 10:00:00	SPY	ETF	210.9	211.2	210.85	211.0	7516177.0
2015-03-03 10:30:00	SPY	ETF	210.99	211.16	210.82	210.9	6060380.0
2015-03-03 11:00:00	SPY	ETF	210.89	210.97	210.67	210.77	8914180.0
2015-03-03 11:30:00	SPY	ETF	210.76	210.77	210.19	210.5	11147655.0
2015-03-03 12:00:00	SPY	ETF	210.49	210.49	210.08	210.261	6682049.0
2015-03-03 12:30:00	SPY	ETF	210.27	210.76	210.23	210.73	5328796.0
2015-03-03 13:00:00	SPY	ETF	210.74	210.9	210.63	210.82	4171693.0
2015-03-03 13:30:00	SPY	ETF	210.83	210.92	210.67	210.745	4202594.0
2015-03-03 14:00:00	SPY	ETF	210.7465	212.054	210.74	211.1962	5538269.0
2015-03-03 14:30:00	SPY	ETF	211.2	211.23	210.81	211.005	4943392.0
2015-03-03 15:00:00	SPY	ETF	211.0	211.15	210.82	211.109	4582164.0
2015-03-03 15:30:00	SPY	ETF	211.1	211.21	210.93	211.14	15085086.0
2015-03-03 16:00:00	SPY	ETF	211.15	212.0539	210.7311	210.96	3948434.0
2015-03-03 16:30:00	SPY	ETF	210.97	211.03	210.95	211.01	4890399.0
2015-03-03 17:00:00	SPY	ETF	211.02	212.0539	210.96	211.0	538915.0
2015-03-03 17:30:00	SPY	ETF	210.96	210.96	210.92	210.94	72347.0
2015-03-03 18:00:00	SPY	ETF	210.94	210.95	210.83	210.83	52155.0
2015-03-03 18:30:00	SPY	ETF	210.84	210.87	210.84	210.87	2864.0
2015-03-03 19:00:00	SPY	ETF	210.87	210.87	210.84	210.85	17691.0
2015-03-03 19:30:00	SPY	ETF	210.87	210.87	210.7	210.72	46065.0
2015-03-03 06:00:00	QQQ	ETF	109.3	109.3	109.27	109.27	300.0
2015-03-03 06:30:00	QQQ	ETF	109.22	109.23	109.22	109.23	20000.0
2015-03-03 07:00:00	QQQ	ETF	109.18	109.18	109.16	109.16	3200.0
2015-03-03 07:30:00	QQQ	ETF	109.14	109.17	109.12	109.12	7234.0
2015-03-03 08:00:00	QQQ	ETF	109.12	109.14	109.02	109.03	34523.0
2015-03-03 08:30:00	QQQ	ETF	109.06	109.07	109.02	109.05	28310.0
2015-03-03 09:00:00	QQQ	ETF	109.04	109.06	109.01	109.04	39753.0
2015-03-03 09:30:00	QQQ	ETF	109.05	109.16	108.7	108.78	2913129.0
2015-03-03 10:00:00	QQQ	ETF	108.79	108.96	108.67	108.71	1880945.0
2015-03-03 10:30:00	QQQ	ETF	108.7199	108.83	108.59	108.65	1330579.0
2015-03-03 11:00:00	QQQ	ETF	108.64	108.66	108.451	108.54	1340607.0
2015-03-03 11:30:00	QQQ	ETF	108.55	108.55	108.3	108.46	1733623.0
2015-03-03 12:00:00	QQQ	ETF	108.47	108.47	108.18	108.27	1231949.0
2015-03-03 12:30:00	QQQ	ETF	108.28	108.57	108.25	108.56	1169852.0
2015-03-03 13:00:00	QQQ	ETF	108.56	108.68	108.49	108.58	872584.0
2015-03-03 13:30:00	QQQ	ETF	108.59	108.66	108.53	108.6	590573.0
2015-03-03 14:00:00	QQQ	ETF	108.595	108.89	108.58	108.89	1199980.0
2015-03-03 14:30:00	QQQ	ETF	108.8822	108.905	108.6601	108.78	924231.0

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

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