PREVIEW / etf_30min / 2016-06-06

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-06-06.parquet
  size:    394 KB
  rows:    13,402

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-06-06 04:00:00	SPY	ETF	210.49	210.6	210.45	210.5	3702.0
2016-06-06 04:30:00	SPY	ETF	210.43	210.58	210.43	210.58	1110.0
2016-06-06 05:00:00	SPY	ETF	210.61	210.61	210.38	210.38	2710.0
2016-06-06 05:30:00	SPY	ETF	210.41	210.57	210.41	210.57	906.0
2016-06-06 06:00:00	SPY	ETF	210.45	210.45	210.35	210.37	1926.0
2016-06-06 06:30:00	SPY	ETF	210.39	210.5	210.39	210.49	11854.0
2016-06-06 07:00:00	SPY	ETF	210.45	210.63	210.45	210.61	15917.0
2016-06-06 07:30:00	SPY	ETF	210.63	210.76	210.61	210.66	52116.0
2016-06-06 08:00:00	SPY	ETF	210.65	210.9	210.031	210.9	349363.0
2016-06-06 08:30:00	SPY	ETF	210.89	210.98	210.83	210.84	183977.0
2016-06-06 09:00:00	SPY	ETF	210.85	210.89	210.69	210.7	194234.0
2016-06-06 09:30:00	SPY	ETF	210.7	211.38	210.5607	211.18	7191874.0
2016-06-06 10:00:00	SPY	ETF	211.19	211.32	211.085	211.15	4021613.0
2016-06-06 10:30:00	SPY	ETF	211.15	211.4	211.15	211.34	3740422.0
2016-06-06 11:00:00	SPY	ETF	211.34	211.445	211.28	211.29	2757048.0
2016-06-06 11:30:00	SPY	ETF	211.28	211.45	211.21	211.24	2253736.0
2016-06-06 12:00:00	SPY	ETF	211.24	211.26	210.99	211.085	3292033.0
2016-06-06 12:30:00	SPY	ETF	211.08	211.32	210.51	210.86	6819419.0
2016-06-06 13:00:00	SPY	ETF	210.86	211.24	210.81	211.17	3643673.0
2016-06-06 13:30:00	SPY	ETF	211.17	211.48	211.1	211.39	2646278.0
2016-06-06 14:00:00	SPY	ETF	211.3901	211.77	211.35	211.71	4123960.0
2016-06-06 14:30:00	SPY	ETF	211.715	211.74	211.545	211.55	2969155.0
2016-06-06 15:00:00	SPY	ETF	211.56	211.64	211.5	211.5	3965483.0
2016-06-06 15:30:00	SPY	ETF	211.505	211.64	211.3	211.35	9186189.0
2016-06-06 16:00:00	SPY	ETF	211.37	211.45	211.33	211.38	3956900.0
2016-06-06 16:30:00	SPY	ETF	211.38	211.47	210.3091	211.42	2283438.0
2016-06-06 17:00:00	SPY	ETF	211.41	211.45	211.4	211.42	71123.0
2016-06-06 17:30:00	SPY	ETF	211.42	211.43	211.32	211.36	130890.0
2016-06-06 18:00:00	SPY	ETF	211.36	211.42	211.33	211.38	48328.0
2016-06-06 18:30:00	SPY	ETF	211.35	211.36	211.34	211.36	3031.0
2016-06-06 19:00:00	SPY	ETF	211.34	211.37	211.34	211.36	24750.0
2016-06-06 19:30:00	SPY	ETF	211.36	211.38	211.22	211.29	40562.0
2016-06-06 05:30:00	QQQ	ETF	110.17	110.2	110.17	110.2	4876.0
2016-06-06 06:30:00	QQQ	ETF	110.19	110.19	110.19	110.19	599.0
2016-06-06 07:00:00	QQQ	ETF	110.2	110.2	110.2	110.2	2390.0
2016-06-06 07:30:00	QQQ	ETF	110.26	110.3	110.26	110.29	19690.0
2016-06-06 08:00:00	QQQ	ETF	110.26	110.37	110.2	110.34	18930.0
2016-06-06 08:30:00	QQQ	ETF	110.33	110.39	110.33	110.34	7265.0
2016-06-06 09:00:00	QQQ	ETF	110.36	110.37	110.26	110.26	58703.0
2016-06-06 09:30:00	QQQ	ETF	110.25	110.54	110.13	110.393	1671605.0
2016-06-06 10:00:00	QQQ	ETF	110.4	110.47	110.3	110.32	941699.0
2016-06-06 10:30:00	QQQ	ETF	110.3201	110.495	110.3201	110.46	662742.0
2016-06-06 11:00:00	QQQ	ETF	110.47	110.59	110.4138	110.46	574097.0
2016-06-06 11:30:00	QQQ	ETF	110.46	110.53	110.39	110.4	440697.0
2016-06-06 12:00:00	QQQ	ETF	110.4	110.41	110.29	110.37	408894.0
2016-06-06 12:30:00	QQQ	ETF	110.36	110.46	110.07	110.24	1392746.0
2016-06-06 13:00:00	QQQ	ETF	110.25	110.47	110.23	110.43	673497.0
2016-06-06 13:30:00	QQQ	ETF	110.43	110.59	110.3837	110.555	730268.0
2016-06-06 14:00:00	QQQ	ETF	110.5699	110.75	110.53	110.72	808780.0
2016-06-06 14:30:00	QQQ	ETF	110.7	110.7163	110.55	110.56	499109.0

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

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