PREVIEW / etf_30min / 2011-01-24

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-01-24.parquet
  size:    273 KB
  rows:    9,054

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
2011-01-24 04:00:00	SPY	ETF	128.65	128.65	128.2	128.36	5550.0
2011-01-24 04:30:00	SPY	ETF	128.34	128.89	128.34	128.7	2500.0
2011-01-24 05:00:00	SPY	ETF	128.43	128.43	128.4	128.4	200.0
2011-01-24 06:00:00	SPY	ETF	128.37	128.4	128.32	128.4	1100.0
2011-01-24 06:30:00	SPY	ETF	128.28	128.4	128.24	128.24	166000.0
2011-01-24 07:00:00	SPY	ETF	128.25	128.37	128.23	128.3	67400.0
2011-01-24 07:30:00	SPY	ETF	128.33	128.5	128.3	128.5	123501.0
2011-01-24 08:00:00	SPY	ETF	128.49	128.5	128.25	128.48	489295.0
2011-01-24 08:30:00	SPY	ETF	128.48	128.57	128.41	128.48	298008.0
2011-01-24 09:00:00	SPY	ETF	128.48	128.54	128.26	128.28	1539715.0
2011-01-24 09:30:00	SPY	ETF	128.285	128.65	128.26	128.3438	12480755.0
2011-01-24 10:00:00	SPY	ETF	128.35	128.68	128.27	128.595	8086322.0
2011-01-24 10:30:00	SPY	ETF	128.6	128.7894	128.53	128.7435	6171605.0
2011-01-24 11:00:00	SPY	ETF	128.75	129.0	128.67	128.94	8538563.0
2011-01-24 11:30:00	SPY	ETF	128.93	129.04	128.86	128.95	6215853.0
2011-01-24 12:00:00	SPY	ETF	128.945	129.16	128.94	128.99	6687045.0
2011-01-24 12:30:00	SPY	ETF	129.0	129.11	128.95	128.9601	3436689.0
2011-01-24 13:00:00	SPY	ETF	128.96	129.11	128.93	129.04	3828051.0
2011-01-24 13:30:00	SPY	ETF	129.04	129.18	128.99	129.07	5183143.0
2011-01-24 14:00:00	SPY	ETF	129.07	129.25	129.03	129.06	5156257.0
2011-01-24 14:30:00	SPY	ETF	129.07	129.14	128.93	128.97	6497761.0
2011-01-24 15:00:00	SPY	ETF	128.96	129.03	128.76	128.78	7722941.0
2011-01-24 15:30:00	SPY	ETF	128.79	129.14	128.785	129.13	14568804.0
2011-01-24 16:00:00	SPY	ETF	129.12	129.35	128.73	129.21	9266991.0
2011-01-24 16:30:00	SPY	ETF	129.21	129.23	129.1	129.16	331773.0
2011-01-24 17:00:00	SPY	ETF	129.16	129.18	129.11	129.11	58341.0
2011-01-24 17:30:00	SPY	ETF	129.12	129.21	129.1	129.16	44852.0
2011-01-24 18:00:00	SPY	ETF	129.16	129.19	129.15	129.19	15552.0
2011-01-24 18:30:00	SPY	ETF	129.19	129.21	129.14	129.14	8083.0
2011-01-24 19:00:00	SPY	ETF	129.16	129.2	129.16	129.19	7402.0
2011-01-24 19:30:00	SPY	ETF	129.18	129.27	129.16	129.23	46620.0
2011-01-24 04:00:00	QQQ	ETF	55.75	55.75	55.75	55.75	100.0
2011-01-24 04:30:00	QQQ	ETF	55.72	55.72	55.72	55.72	100.0
2011-01-24 06:30:00	QQQ	ETF	55.7	55.7	55.67	55.67	27000.0
2011-01-24 07:00:00	QQQ	ETF	55.67	55.7	55.67	55.7	27300.0
2011-01-24 07:30:00	QQQ	ETF	55.71	55.78	55.71	55.76	13526.0
2011-01-24 08:00:00	QQQ	ETF	55.77	55.79	55.68	55.75	58752.0
2011-01-24 08:30:00	QQQ	ETF	55.75	55.8	55.73	55.74	110784.0
2011-01-24 09:00:00	QQQ	ETF	55.74	55.8	55.67	55.79	357441.0
2011-01-24 09:30:00	QQQ	ETF	55.79	55.99	55.69	55.73	7370545.0
2011-01-24 10:00:00	QQQ	ETF	55.74	55.94	55.68	55.9	6214910.0
2011-01-24 10:30:00	QQQ	ETF	55.91	55.99	55.88	55.96	4389179.0
2011-01-24 11:00:00	QQQ	ETF	55.95	56.22	55.92	56.219	5005351.0
2011-01-24 11:30:00	QQQ	ETF	56.21	56.26	56.16	56.231	2997971.0
2011-01-24 12:00:00	QQQ	ETF	56.23	56.38	56.23	56.3	3936566.0
2011-01-24 12:30:00	QQQ	ETF	56.295	56.38	56.29	56.33	1477300.0
2011-01-24 13:00:00	QQQ	ETF	56.32	56.43	56.3	56.39	1871453.0
2011-01-24 13:30:00	QQQ	ETF	56.38	56.46	56.34	56.355	3628164.0
2011-01-24 14:00:00	QQQ	ETF	56.35	56.45	56.34	56.41	2735277.0
2011-01-24 14:30:00	QQQ	ETF	56.41	56.46	56.36	56.38	2352443.0

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

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