PREVIEW / etf_30min / 2010-06-01

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-06-01.parquet
  size:    259 KB
  rows:    8,674

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
2010-06-01 04:00:00	SPY	ETF	108.04	108.22	107.97	107.97	24969.0
2010-06-01 04:30:00	SPY	ETF	107.98	108.09	107.55	107.67	23300.0
2010-06-01 05:00:00	SPY	ETF	107.74	107.79	107.49	107.49	10200.0
2010-06-01 05:30:00	SPY	ETF	107.77	107.88	107.77	107.88	2700.0
2010-06-01 06:00:00	SPY	ETF	107.78	107.88	107.75	107.88	25300.0
2010-06-01 06:30:00	SPY	ETF	107.86	107.95	107.83	107.89	43100.0
2010-06-01 07:00:00	SPY	ETF	107.95	108.13	107.75	107.91	546936.0
2010-06-01 07:30:00	SPY	ETF	107.92	108.05	107.83	107.9	168215.0
2010-06-01 08:00:00	SPY	ETF	107.9	110.15	107.76	107.87	1797179.0
2010-06-01 08:30:00	SPY	ETF	107.86	108.05	107.84	107.92	1453991.0
2010-06-01 09:00:00	SPY	ETF	107.93	109.369	107.93	108.35	1879208.0
2010-06-01 09:30:00	SPY	ETF	108.35	108.89	108.19	108.55	35571935.0
2010-06-01 10:00:00	SPY	ETF	108.55	109.88	108.55	109.68	31078905.0
2010-06-01 10:30:00	SPY	ETF	109.69	109.95	109.1786	109.54	19072151.0
2010-06-01 11:00:00	SPY	ETF	109.54	109.58	109.14	109.42	15196768.0
2010-06-01 11:30:00	SPY	ETF	109.42	109.5227	108.79	108.88	15591139.0
2010-06-01 12:00:00	SPY	ETF	108.87	109.25	108.79	109.22	10123711.0
2010-06-01 12:30:00	SPY	ETF	109.22	109.36	108.93	108.9599	7156197.0
2010-06-01 13:00:00	SPY	ETF	108.975	109.7	108.94	109.668	9682845.0
2010-06-01 13:30:00	SPY	ETF	109.67	109.75	109.25	109.29	11440834.0
2010-06-01 14:00:00	SPY	ETF	109.25	109.6	108.7	109.1	19130707.0
2010-06-01 14:30:00	SPY	ETF	109.09	109.39	108.83	109.07	13656201.0
2010-06-01 15:00:00	SPY	ETF	109.08	109.3621	108.29	108.53	23679854.0
2010-06-01 15:30:00	SPY	ETF	108.53	108.81	107.37	107.52	41646843.0
2010-06-01 16:00:00	SPY	ETF	107.51	109.6872	107.38	107.49	11711711.0
2010-06-01 16:30:00	SPY	ETF	107.45	107.55	107.27	107.54	5922313.0
2010-06-01 17:00:00	SPY	ETF	107.54	107.54	107.3	107.31	185609.0
2010-06-01 17:30:00	SPY	ETF	107.3	107.39	107.16	107.25	136383.0
2010-06-01 18:00:00	SPY	ETF	107.25	107.52	107.23	107.44	360933.0
2010-06-01 18:30:00	SPY	ETF	107.44	107.45	107.4	107.45	34650.0
2010-06-01 19:00:00	SPY	ETF	107.46	107.69	107.44	107.6	101613.0
2010-06-01 19:30:00	SPY	ETF	107.59	107.67	107.52	107.66	60332.0
2010-06-01 04:00:00	QQQ	ETF	45.29	45.29	45.15	45.15	5108.0
2010-06-01 04:30:00	QQQ	ETF	45.11	45.11	44.99	44.99	1385.0
2010-06-01 05:00:00	QQQ	ETF	45.0	45.0	45.0	45.0	200.0
2010-06-01 05:30:00	QQQ	ETF	45.11	45.11	45.1	45.1	25500.0
2010-06-01 06:30:00	QQQ	ETF	45.08	45.08	45.08	45.08	100.0
2010-06-01 07:00:00	QQQ	ETF	45.15	45.2	45.1	45.14	81215.0
2010-06-01 07:30:00	QQQ	ETF	45.19	45.24	45.16	45.21	231742.0
2010-06-01 08:00:00	QQQ	ETF	45.2	45.32	45.2	45.28	435186.0
2010-06-01 08:30:00	QQQ	ETF	45.26	45.62	45.26	45.34	125860.0
2010-06-01 09:00:00	QQQ	ETF	45.34	45.6	45.33	45.45	563618.0
2010-06-01 09:30:00	QQQ	ETF	45.45	45.73	45.35	45.55	11923329.0
2010-06-01 10:00:00	QQQ	ETF	45.55	46.25	45.55	46.15	11338550.0
2010-06-01 10:30:00	QQQ	ETF	46.15	46.25	45.98	46.0	8151081.0
2010-06-01 11:00:00	QQQ	ETF	46.0	46.02	45.83	45.94	6617586.0
2010-06-01 11:30:00	QQQ	ETF	45.94	45.98	45.64	45.66	4797304.0
2010-06-01 12:00:00	QQQ	ETF	45.66	45.87	45.62	45.86	3947394.0
2010-06-01 12:30:00	QQQ	ETF	45.86	45.93	45.77	45.78	2659907.0
2010-06-01 13:00:00	QQQ	ETF	45.78	46.12	45.77	46.11	4392482.0

> showing 50 of 8,674 rows — these rows as CSV

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