PREVIEW / etf_30min / 2013-06-10

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-06-10.parquet
  size:    313 KB
  rows:    10,967

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
2013-06-10 04:00:00	SPY	ETF	164.85	165.17	164.5	164.96	52250.0
2013-06-10 04:30:00	SPY	ETF	165.0	165.08	164.96	165.08	1350.0
2013-06-10 05:00:00	SPY	ETF	165.08	165.14	165.0	165.04	76025.0
2013-06-10 05:30:00	SPY	ETF	165.08	165.11	165.08	165.1	1400.0
2013-06-10 06:00:00	SPY	ETF	165.05	165.05	164.96	165.01	1750.0
2013-06-10 06:30:00	SPY	ETF	165.02	165.08	165.0	165.06	81923.0
2013-06-10 07:00:00	SPY	ETF	165.03	165.24	165.03	165.11	127725.0
2013-06-10 07:30:00	SPY	ETF	165.1	165.1	164.96	165.0	148837.0
2013-06-10 08:00:00	SPY	ETF	165.06	165.16	164.5	164.83	919459.0
2013-06-10 08:30:00	SPY	ETF	164.83	165.15	164.72	165.06	1069089.0
2013-06-10 09:00:00	SPY	ETF	165.05	165.38	164.21	165.3	1287024.0
2013-06-10 09:30:00	SPY	ETF	165.31	165.4	164.65	164.76	17020281.0
2013-06-10 10:00:00	SPY	ETF	164.77	164.8696	164.37	164.835	11819545.0
2013-06-10 10:30:00	SPY	ETF	164.84	165.17	164.8	165.02	6043486.0
2013-06-10 11:00:00	SPY	ETF	165.02	165.24	164.97	164.97	4822113.0
2013-06-10 11:30:00	SPY	ETF	164.975	165.2	164.85	165.07	5709824.0
2013-06-10 12:00:00	SPY	ETF	165.07	165.29	165.05	165.104	3761183.0
2013-06-10 12:30:00	SPY	ETF	165.11	165.11	164.72	164.78	4143627.0
2013-06-10 13:00:00	SPY	ETF	164.79	164.92	164.68	164.8	3355440.0
2013-06-10 13:30:00	SPY	ETF	164.81	164.83	164.54	164.78	4124740.0
2013-06-10 14:00:00	SPY	ETF	164.79	164.81	164.47	164.72	5271860.0
2013-06-10 14:30:00	SPY	ETF	164.71	164.99	164.59	164.97	4205698.0
2013-06-10 15:00:00	SPY	ETF	164.96	164.98	164.66	164.82	4289430.0
2013-06-10 15:30:00	SPY	ETF	164.81	164.93	164.54	164.76	9459426.0
2013-06-10 16:00:00	SPY	ETF	164.77	164.8585	164.5	164.83	4023322.0
2013-06-10 16:30:00	SPY	ETF	164.83	164.83	164.7309	164.76	3258201.0
2013-06-10 17:00:00	SPY	ETF	164.77	164.88	164.76	164.78	41843.0
2013-06-10 17:30:00	SPY	ETF	164.8	164.82	164.75	164.76	5977892.0
2013-06-10 18:00:00	SPY	ETF	164.75	164.8	164.69	164.7	63625.0
2013-06-10 18:30:00	SPY	ETF	164.71	164.76	164.7	164.76	26000.0
2013-06-10 19:00:00	SPY	ETF	164.75	164.77	164.75	164.75	700.0
2013-06-10 19:30:00	SPY	ETF	164.75	164.75	164.71	164.75	33629.0
2013-06-10 04:00:00	QQQ	ETF	73.46	73.52	73.44	73.46	7700.0
2013-06-10 04:30:00	QQQ	ETF	73.48	73.48	73.46	73.48	1200.0
2013-06-10 05:00:00	QQQ	ETF	73.46	73.46	73.44	73.46	1200.0
2013-06-10 05:30:00	QQQ	ETF	73.44	73.48	73.44	73.48	1200.0
2013-06-10 06:00:00	QQQ	ETF	73.46	73.46	73.42	73.44	1900.0
2013-06-10 06:30:00	QQQ	ETF	73.46	73.46	73.46	73.46	700.0
2013-06-10 07:00:00	QQQ	ETF	73.47	73.52	73.46	73.46	20129.0
2013-06-10 07:30:00	QQQ	ETF	73.44	73.44	73.44	73.44	4300.0
2013-06-10 08:00:00	QQQ	ETF	73.46	73.52	73.34	73.34	657407.0
2013-06-10 08:30:00	QQQ	ETF	73.32	73.43	73.3	73.42	80364.0
2013-06-10 09:00:00	QQQ	ETF	73.43	73.55	73.39	73.53	183460.0
2013-06-10 09:30:00	QQQ	ETF	73.54	73.55	73.35	73.47	4028922.0
2013-06-10 10:00:00	QQQ	ETF	73.48	73.53	73.33	73.51	2447187.0
2013-06-10 10:30:00	QQQ	ETF	73.5099	73.71	73.5	73.64	1740761.0
2013-06-10 11:00:00	QQQ	ETF	73.64	73.72	73.611	73.62	1516175.0
2013-06-10 11:30:00	QQQ	ETF	73.62	73.74	73.58	73.68	2179937.0
2013-06-10 12:00:00	QQQ	ETF	73.69	73.76	73.64	73.67	953558.0
2013-06-10 12:30:00	QQQ	ETF	73.66	73.66	73.49	73.5	1157085.0

> showing 50 of 10,967 rows — these rows as CSV

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