PREVIEW / etf_30min / 2018-04-18

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-04-18.parquet
  size:    464 KB
  rows:    15,991

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
2018-04-18 04:00:00	SPY	ETF	270.63	270.88	270.63	270.88	4525.0
2018-04-18 04:30:00	SPY	ETF	270.9	270.9	270.77	270.77	5625.0
2018-04-18 05:00:00	SPY	ETF	270.7	270.78	270.7	270.78	2225.0
2018-04-18 05:30:00	SPY	ETF	270.67	270.68	270.67	270.68	730.0
2018-04-18 06:00:00	SPY	ETF	270.52	270.73	270.52	270.72	4320.0
2018-04-18 06:30:00	SPY	ETF	270.73	270.98	270.73	270.96	10129.0
2018-04-18 07:00:00	SPY	ETF	270.95	271.32	270.95	271.27	135458.0
2018-04-18 07:30:00	SPY	ETF	271.26	271.35	271.23	271.31	83916.0
2018-04-18 08:00:00	SPY	ETF	270.89	271.37	270.54	271.11	310482.0
2018-04-18 08:30:00	SPY	ETF	271.12	271.17	271.01	271.05	107871.0
2018-04-18 09:00:00	SPY	ETF	271.04	271.08	270.7	270.7	390163.0
2018-04-18 09:30:00	SPY	ETF	270.69	271.14	270.46	270.705	6073543.0
2018-04-18 10:00:00	SPY	ETF	270.7	270.72	269.87	270.525	6041411.0
2018-04-18 10:30:00	SPY	ETF	270.52	270.98	270.52	270.95	3529448.0
2018-04-18 11:00:00	SPY	ETF	270.95	271.3	270.92	271.1455	2715892.0
2018-04-18 11:30:00	SPY	ETF	271.15	271.21	270.75	270.75	2172105.0
2018-04-18 12:00:00	SPY	ETF	270.76	271.14	270.76	270.92	1901320.0
2018-04-18 12:30:00	SPY	ETF	270.92	270.98	270.6	270.915	3555966.0
2018-04-18 13:00:00	SPY	ETF	270.91	271.1569	270.84	270.94	3186850.0
2018-04-18 13:30:00	SPY	ETF	270.9486	271.0	270.54	270.571	2600289.0
2018-04-18 14:00:00	SPY	ETF	270.57	271.12	270.36	271.06	3103033.0
2018-04-18 14:30:00	SPY	ETF	271.05	271.19	270.81	270.87	2657331.0
2018-04-18 15:00:00	SPY	ETF	270.87	271.13	270.75	270.8499	4805050.0
2018-04-18 15:30:00	SPY	ETF	270.85	270.9	270.34	270.37	6287503.0
2018-04-18 16:00:00	SPY	ETF	270.37	270.6	270.31	270.46	4824811.0
2018-04-18 16:30:00	SPY	ETF	270.46	270.58	270.19	270.55	831600.0
2018-04-18 17:00:00	SPY	ETF	270.57	270.68	270.53	270.68	359497.0
2018-04-18 17:30:00	SPY	ETF	270.67	270.67	270.39	270.63	75206.0
2018-04-18 18:00:00	SPY	ETF	270.63	270.7	270.58	270.7	120402.0
2018-04-18 18:30:00	SPY	ETF	270.71	270.72	270.61	270.64	17970.0
2018-04-18 19:00:00	SPY	ETF	270.7	270.72	270.65	270.7	7188.0
2018-04-18 19:30:00	SPY	ETF	270.7	270.8	270.69	270.8	26812.0
2018-04-18 04:00:00	QQQ	ETF	166.54	166.54	166.54	166.54	5168.0
2018-04-18 04:30:00	QQQ	ETF	166.64	166.66	166.54	166.55	3400.0
2018-04-18 05:00:00	QQQ	ETF	166.56	166.63	166.5	166.5	4011.0
2018-04-18 05:30:00	QQQ	ETF	166.48	166.5	166.37	166.38	26545.0
2018-04-18 06:00:00	QQQ	ETF	166.34	166.45	166.3	166.37	3099.0
2018-04-18 06:30:00	QQQ	ETF	166.37	166.55	166.36	166.55	9000.0
2018-04-18 07:00:00	QQQ	ETF	166.56	166.79	166.51	166.69	84285.0
2018-04-18 07:30:00	QQQ	ETF	166.7	166.74	166.62	166.67	19382.0
2018-04-18 08:00:00	QQQ	ETF	166.56	166.75	166.45	166.5	65453.0
2018-04-18 08:30:00	QQQ	ETF	166.52	166.58	166.41	166.47	64643.0
2018-04-18 09:00:00	QQQ	ETF	166.45	166.48	166.11	166.14	233920.0
2018-04-18 09:30:00	QQQ	ETF	166.13	166.39	165.7008	165.97	4331646.0
2018-04-18 10:00:00	QQQ	ETF	165.98	165.98	165.31	165.89	2691879.0
2018-04-18 10:30:00	QQQ	ETF	165.885	166.34	165.86	166.3	1554299.0
2018-04-18 11:00:00	QQQ	ETF	166.3	166.68	166.29	166.569	1271383.0
2018-04-18 11:30:00	QQQ	ETF	166.57	166.6	166.25	166.38	1045516.0
2018-04-18 12:00:00	QQQ	ETF	166.38	166.79	166.38	166.715	878931.0
2018-04-18 12:30:00	QQQ	ETF	166.71	166.77	166.45	166.689	786115.0

> showing 50 of 15,991 rows — these rows as CSV

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