PREVIEW / etf_30min / 2012-01-18

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-01-18.parquet
  size:    293 KB
  rows:    9,785

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
2012-01-18 04:00:00	SPY	ETF	129.47	129.47	129.32	129.32	7752.0
2012-01-18 04:30:00	SPY	ETF	129.33	129.64	129.33	129.52	1600.0
2012-01-18 05:00:00	SPY	ETF	129.83	130.2	129.83	130.08	12537.0
2012-01-18 05:30:00	SPY	ETF	130.06	130.06	129.9	130.0	15290.0
2012-01-18 06:00:00	SPY	ETF	129.75	129.75	129.75	129.75	6000.0
2012-01-18 06:30:00	SPY	ETF	129.85	129.85	129.77	129.82	2096.0
2012-01-18 07:00:00	SPY	ETF	129.89	129.89	129.48	129.62	127947.0
2012-01-18 07:30:00	SPY	ETF	129.58	129.82	129.53	129.65	181476.0
2012-01-18 08:00:00	SPY	ETF	129.63	129.72	129.51	129.69	380247.0
2012-01-18 08:30:00	SPY	ETF	129.68	130.07	129.25	129.29	1013400.0
2012-01-18 09:00:00	SPY	ETF	129.27	129.35	129.14	129.31	1115944.0
2012-01-18 09:30:00	SPY	ETF	129.31	129.88	129.08	129.82	19212169.0
2012-01-18 10:00:00	SPY	ETF	129.82	130.19	129.791	130.12	12375330.0
2012-01-18 10:30:00	SPY	ETF	130.12	130.28	130.0	130.1	11358997.0
2012-01-18 11:00:00	SPY	ETF	130.1	130.21	129.99	130.02	8192818.0
2012-01-18 11:30:00	SPY	ETF	130.02	130.17	129.875	129.98	7724618.0
2012-01-18 12:00:00	SPY	ETF	129.99	130.42	129.98	130.37	7947658.0
2012-01-18 12:30:00	SPY	ETF	130.38	130.5	130.31	130.4517	7097106.0
2012-01-18 13:00:00	SPY	ETF	130.45	130.48	130.33	130.4	4786545.0
2012-01-18 13:30:00	SPY	ETF	130.4	130.56	130.26	130.2789	6602711.0
2012-01-18 14:00:00	SPY	ETF	130.27	130.63	130.27	130.63	8577905.0
2012-01-18 14:30:00	SPY	ETF	130.625	130.63	130.43	130.54	8415730.0
2012-01-18 15:00:00	SPY	ETF	130.55	130.84	130.53	130.73	15175361.0
2012-01-18 15:30:00	SPY	ETF	130.73	130.78	130.61	130.78	17862561.0
2012-01-18 16:00:00	SPY	ETF	130.77	130.811	129.3753	130.67	15691566.0
2012-01-18 16:30:00	SPY	ETF	130.7	130.8033	130.66	130.73	2648287.0
2012-01-18 17:00:00	SPY	ETF	130.73	130.77	130.65	130.76	101878.0
2012-01-18 17:30:00	SPY	ETF	130.75	130.76	130.68	130.73	18545.0
2012-01-18 18:00:00	SPY	ETF	130.73	130.8	130.73	130.79	134934.0
2012-01-18 18:30:00	SPY	ETF	130.79	130.79	130.7	130.71	177283.0
2012-01-18 19:00:00	SPY	ETF	130.74	130.77	130.68	130.7	57456.0
2012-01-18 19:30:00	SPY	ETF	130.68	130.76	130.62	130.69	123826.0
2012-01-18 05:00:00	QQQ	ETF	59.04	59.05	59.03	59.03	3500.0
2012-01-18 05:30:00	QQQ	ETF	59.03	59.03	58.99	58.99	9800.0
2012-01-18 06:00:00	QQQ	ETF	58.95	58.95	58.93	58.93	400.0
2012-01-18 06:30:00	QQQ	ETF	58.95	58.97	58.93	58.97	5600.0
2012-01-18 07:00:00	QQQ	ETF	58.95	58.95	58.86	58.89	9300.0
2012-01-18 07:30:00	QQQ	ETF	58.88	58.96	58.88	58.95	10500.0
2012-01-18 08:00:00	QQQ	ETF	58.9	58.95	58.86	58.93	114171.0
2012-01-18 08:30:00	QQQ	ETF	58.92	58.96	58.8	58.8	106440.0
2012-01-18 09:00:00	QQQ	ETF	58.78	58.84	58.74	58.83	59878.0
2012-01-18 09:30:00	QQQ	ETF	58.84	58.99	58.71	58.92	5328548.0
2012-01-18 10:00:00	QQQ	ETF	58.92	59.13	58.91	59.1	3711030.0
2012-01-18 10:30:00	QQQ	ETF	59.091	59.18	59.06	59.12	3246708.0
2012-01-18 11:00:00	QQQ	ETF	59.13	59.18	59.09	59.13	2726453.0
2012-01-18 11:30:00	QQQ	ETF	59.125	59.22	59.07	59.1	2355897.0
2012-01-18 12:00:00	QQQ	ETF	59.1	59.34	59.08	59.31	2643466.0
2012-01-18 12:30:00	QQQ	ETF	59.31	59.39	59.29	59.37	2191040.0
2012-01-18 13:00:00	QQQ	ETF	59.37	59.38	59.31	59.37	1227634.0
2012-01-18 13:30:00	QQQ	ETF	59.37	59.45	59.3	59.31	2505930.0

> showing 50 of 9,785 rows — these rows as CSV

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