PREVIEW / etf_30min / 2015-01-30

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-01-30.parquet
  size:    387 KB
  rows:    12,994

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-01-30 04:00:00	SPY	ETF	201.81	201.81	200.74	200.83	15921.0
2015-01-30 04:30:00	SPY	ETF	200.92	201.1	200.73	200.8	42300.0
2015-01-30 05:00:00	SPY	ETF	200.77	200.98	200.75	200.75	8035.0
2015-01-30 05:30:00	SPY	ETF	200.78	200.84	200.58	200.84	421289.0
2015-01-30 06:00:00	SPY	ETF	200.86	201.24	200.79	201.19	46811.0
2015-01-30 06:30:00	SPY	ETF	201.11	201.39	201.02	201.14	60015.0
2015-01-30 07:00:00	SPY	ETF	201.11	201.11	200.78	200.96	141983.0
2015-01-30 07:30:00	SPY	ETF	200.98	201.06	200.71	200.76	225267.0
2015-01-30 08:00:00	SPY	ETF	200.78	201.06	200.22	200.38	1032378.0
2015-01-30 08:30:00	SPY	ETF	200.32	201.97	200.02	200.22	1809858.0
2015-01-30 09:00:00	SPY	ETF	200.2	200.58	200.12	200.57	1645589.0
2015-01-30 09:30:00	SPY	ETF	200.57	201.71	200.41	201.15	17276362.0
2015-01-30 10:00:00	SPY	ETF	201.15	201.4	200.48	200.59	10268472.0
2015-01-30 10:30:00	SPY	ETF	200.59	200.86	200.05	200.6	10175250.0
2015-01-30 11:00:00	SPY	ETF	200.59	200.8	199.8	200.36	10899656.0
2015-01-30 11:30:00	SPY	ETF	200.36	200.64	199.88	200.61	8733677.0
2015-01-30 12:00:00	SPY	ETF	200.6	201.45	200.59	201.27	8021075.0
2015-01-30 12:30:00	SPY	ETF	201.275	201.3	200.5	200.61	5187333.0
2015-01-30 13:00:00	SPY	ETF	200.61	200.91	200.28	200.6832	6500517.0
2015-01-30 13:30:00	SPY	ETF	200.69	201.45	200.57	201.43	6822051.0
2015-01-30 14:00:00	SPY	ETF	201.435	202.08	201.11	202.08	11708579.0
2015-01-30 14:30:00	SPY	ETF	202.08	202.17	200.53	200.7	13769298.0
2015-01-30 15:00:00	SPY	ETF	200.7	202.1499	199.68	200.33	16359902.0
2015-01-30 15:30:00	SPY	ETF	200.335	200.41	199.13	199.44	37202850.0
2015-01-30 16:00:00	SPY	ETF	199.45	201.0222	199.24	199.55	11539423.0
2015-01-30 16:30:00	SPY	ETF	199.55	201.9402	199.31	199.38	6424975.0
2015-01-30 17:00:00	SPY	ETF	199.39	201.9405	199.36	199.42	1728585.0
2015-01-30 17:30:00	SPY	ETF	199.45	199.45	199.37	199.38	3725837.0
2015-01-30 18:00:00	SPY	ETF	199.4	199.4	199.17	199.18	118131.0
2015-01-30 18:30:00	SPY	ETF	199.2	199.2	199.11	199.15	61415.0
2015-01-30 19:00:00	SPY	ETF	199.12	201.9401	199.11	199.11	1024389.0
2015-01-30 19:30:00	SPY	ETF	199.19	199.23	199.11	199.23	19667.0
2015-01-30 04:30:00	QQQ	ETF	101.83	101.88	101.83	101.88	1200.0
2015-01-30 05:30:00	QQQ	ETF	101.84	101.84	101.63	101.66	3500.0
2015-01-30 06:00:00	QQQ	ETF	101.81	102.06	101.79	101.99	9300.0
2015-01-30 06:30:00	QQQ	ETF	102.0	102.02	101.9	101.9	11100.0
2015-01-30 07:00:00	QQQ	ETF	101.9	101.9	101.76	101.78	98495.0
2015-01-30 07:30:00	QQQ	ETF	101.88	101.89	101.72	101.74	52279.0
2015-01-30 08:00:00	QQQ	ETF	101.82	101.87	101.58	101.58	66089.0
2015-01-30 08:30:00	QQQ	ETF	101.56	101.74	101.48	101.61	139634.0
2015-01-30 09:00:00	QQQ	ETF	101.6	101.85	101.57	101.81	196906.0
2015-01-30 09:30:00	QQQ	ETF	101.8	102.58	101.75	102.03	5857885.0
2015-01-30 10:00:00	QQQ	ETF	102.03	102.21	101.65	101.77	2702098.0
2015-01-30 10:30:00	QQQ	ETF	101.77	101.84	101.4	101.79	2186576.0
2015-01-30 11:00:00	QQQ	ETF	101.79	101.99	101.52	101.82	1717759.0
2015-01-30 11:30:00	QQQ	ETF	101.82	102.02	101.58	102.0	1060362.0
2015-01-30 12:00:00	QQQ	ETF	102.0	102.459	102.0	102.45	2353409.0
2015-01-30 12:30:00	QQQ	ETF	102.44	102.4401	101.98	102.04	1778416.0
2015-01-30 13:00:00	QQQ	ETF	102.04	102.175	101.8	101.99	1166949.0
2015-01-30 13:30:00	QQQ	ETF	101.98	102.28	101.9	102.23	1598980.0

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

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