PREVIEW / etf_30min / 2013-10-25

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-10-25.parquet
  size:    316 KB
  rows:    10,840

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-10-25 04:00:00	SPY	ETF	174.84	175.32	174.75	174.99	99490.0
2013-10-25 04:30:00	SPY	ETF	175.02	175.11	174.97	175.11	55224.0
2013-10-25 05:00:00	SPY	ETF	175.08	175.08	175.02	175.08	199927.0
2013-10-25 05:30:00	SPY	ETF	175.08	175.26	175.06	175.26	522550.0
2013-10-25 06:00:00	SPY	ETF	175.25	175.25	175.15	175.18	123400.0
2013-10-25 06:30:00	SPY	ETF	175.18	175.25	175.13	175.25	170617.0
2013-10-25 07:00:00	SPY	ETF	175.26	175.38	175.24	175.38	915142.0
2013-10-25 07:30:00	SPY	ETF	175.39	175.43	175.35	175.35	210748.0
2013-10-25 08:00:00	SPY	ETF	175.41	175.42	175.32	175.36	212448.0
2013-10-25 08:30:00	SPY	ETF	175.33	175.4	175.17	175.4	608067.0
2013-10-25 09:00:00	SPY	ETF	175.4	175.56	175.32	175.52	622880.0
2013-10-25 09:30:00	SPY	ETF	175.51	175.68	175.4	175.63	9956684.0
2013-10-25 10:00:00	SPY	ETF	175.63	175.84	175.29	175.3101	9976371.0
2013-10-25 10:30:00	SPY	ETF	175.31	175.51	175.24	175.439	6314171.0
2013-10-25 11:00:00	SPY	ETF	175.43	175.54	175.28	175.49	5507823.0
2013-10-25 11:30:00	SPY	ETF	175.48	175.65	175.29	175.38	6444446.0
2013-10-25 12:00:00	SPY	ETF	175.38	175.42	175.17	175.4097	4269254.0
2013-10-25 12:30:00	SPY	ETF	175.41	175.52	175.36	175.5	2816178.0
2013-10-25 13:00:00	SPY	ETF	175.5	175.6	175.41	175.47	4291636.0
2013-10-25 13:30:00	SPY	ETF	175.4728	175.52	175.39	175.51	1609325.0
2013-10-25 14:00:00	SPY	ETF	175.5	175.7	175.47	175.65	3096129.0
2013-10-25 14:30:00	SPY	ETF	175.66	175.665	175.55	175.66	2830122.0
2013-10-25 15:00:00	SPY	ETF	175.65	175.67	175.49	175.558	3626664.0
2013-10-25 15:30:00	SPY	ETF	175.55	175.96	175.545	175.93	14914464.0
2013-10-25 16:00:00	SPY	ETF	175.95	176.05	175.31	175.84	8673950.0
2013-10-25 16:30:00	SPY	ETF	175.85	175.95	175.82	175.88	2114235.0
2013-10-25 17:00:00	SPY	ETF	175.89	175.89	175.82	175.88	61090.0
2013-10-25 17:30:00	SPY	ETF	175.89	175.9	175.7	175.75	70099.0
2013-10-25 18:00:00	SPY	ETF	175.74	175.89	175.74	175.87	31473.0
2013-10-25 18:30:00	SPY	ETF	175.88	175.88	175.79	175.81	6158.0
2013-10-25 19:00:00	SPY	ETF	175.83	175.83	175.81	175.83	4056.0
2013-10-25 19:30:00	SPY	ETF	175.83	175.83	175.81	175.83	12355.0
2013-10-25 04:00:00	QQQ	ETF	82.7	82.78	82.7	82.77	41977.0
2013-10-25 04:30:00	QQQ	ETF	82.76	82.82	82.75	82.82	7880.0
2013-10-25 05:00:00	QQQ	ETF	82.83	82.86	82.81	82.86	5900.0
2013-10-25 05:30:00	QQQ	ETF	82.85	82.91	82.85	82.91	2400.0
2013-10-25 06:00:00	QQQ	ETF	82.92	82.93	82.86	82.89	14600.0
2013-10-25 06:30:00	QQQ	ETF	82.88	82.92	82.85	82.92	23500.0
2013-10-25 07:00:00	QQQ	ETF	82.93	83.03	82.93	83.02	45255.0
2013-10-25 07:30:00	QQQ	ETF	83.03	83.03	82.95	82.95	28400.0
2013-10-25 08:00:00	QQQ	ETF	82.94	83.03	82.93	82.95	108389.0
2013-10-25 08:30:00	QQQ	ETF	82.95	83.01	82.87	83.01	184661.0
2013-10-25 09:00:00	QQQ	ETF	83.02	83.11	82.97	83.1	424058.0
2013-10-25 09:30:00	QQQ	ETF	83.1	83.24	82.8796	83.2	6310767.0
2013-10-25 10:00:00	QQQ	ETF	83.21	83.28	82.86	82.89	3630465.0
2013-10-25 10:30:00	QQQ	ETF	82.89	83.0	82.84	82.8901	1827759.0
2013-10-25 11:00:00	QQQ	ETF	82.899	82.922	82.73	82.8	2020070.0
2013-10-25 11:30:00	QQQ	ETF	82.8	82.89	82.5899	82.63	2297342.0
2013-10-25 12:00:00	QQQ	ETF	82.63	82.699	82.5	82.675	1638579.0
2013-10-25 12:30:00	QQQ	ETF	82.68	82.74	82.65	82.73	892870.0

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

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